Help Formatting

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi, I have a spreadsheet that is mesbehaving badly.

For some strange reason all of my columns that are formatted as
'General' have reformatted themselves as 07/01/1900 00:00:00 for no
reason at all..

Can anyone advise how I can get the format to stay as originally
intended, or why my spreadsheet is behaving this way?

Thanks


Steve
 
Hi Steve,

Am Sun, 15 Sep 2013 23:00:46 +0100 schrieb Steve:
For some strange reason all of my columns that are formatted as
'General' have reformatted themselves as 07/01/1900 00:00:00 for no
reason at all..
Click to expand...

if your format is "General" you let Excel decide what format the cells
may have. And if in adjacent cells is a date Excel "thinks" that all
other cells should be dates. Format your cells as "Number".


Regards
Claus B.
 
Thanks Claus, they were originally formatted as number when they
suddently changed to the format below for no apparent reason.

It was then that I changed it to general having researched it on the
net.

However, it has not resolved the problem so I wil go back and
re-format as number as adviced.

Cheers

Steve
 
Hi Claus, I have changed all the formats back to number with no
decimals yet excel keeps changing them randomly to the time format -
it is very frustrating !!!!


Is there any way to lock the format so that it cannot be changed.

Thanks in advance


Steve
 
Hi Steve,

Am Thu, 19 Sep 2013 10:53:09 +0100 schrieb Steve:
Hi Claus, I have changed all the formats back to number with no
decimals yet excel keeps changing them randomly to the time format -
it is very frustrating !!!!
Click to expand...

some of your values seems to be incorrect.
Click in the column header => format the column with your numberformat
=>with selected column Choose Data => TextToColumns => Fixed Width =>
Finish.
Repeat it for all your columns with numbers.
If it doesn't work please send me the file.


Regards
Claus B.
 
Ok will do Claus - thanks

Steve

Hi Steve,

Am Thu, 19 Sep 2013 10:53:09 +0100 schrieb Steve:


some of your values seems to be incorrect.
Click in the column header => format the column with your numberformat
=>with selected column Choose Data => TextToColumns => Fixed Width =>
Finish.
Repeat it for all your columns with numbers.
If it doesn't work please send me the file.


Regards
Claus B.
Click to expand...
 
Back
Top