I have an excel 2000 spreadsheet that is altering the format of my numbers. I
have changed the format several times but it does not matter it always
changes the format back to another setting. For example when i type in a
whole number it is changed to a decimal. I type in a number like 0800 for
time and it changes it to a zip code for Portugal. I have checked the
options and custom settings, the cell format settings and everywhere else but
no luck.

Any help or suggestions would be greatly appreciated.

Thanks,
Dell

First problem......

ToolsOptionsEdit. Uncheck "fixed decimal places"

Second problem...........

Times cannot be entered in that manner unless you want a "text" time in which
case type an apostrophe then 0800.

For a real time enter as 8:00 for AM or 16:00 for PM


Gord Dibben MS Excel MVP

On Tue, 15 Aug 2006 07:11:02 -0700, Dell wrote:

I have an excel 2000 spreadsheet that is altering the format of my numbers. I
have changed the format several times but it does not matter it always
changes the format back to another setting. For example when i type in a
whole number it is changed to a decimal. I type in a number like 0800 for
time and it changes it to a zip code for Portugal. I have checked the
options and custom settings, the cell format settings and everywhere else but
no luck.

Any help or suggestions would be greatly appreciated.

Thanks,
Dell

Excellent, I made the changes and everything appears to be working ok.

Thanks,
Dell

"Gord Dibben" wrote:

First problem......

ToolsOptionsEdit. Uncheck "fixed decimal places"

Second problem...........

Times cannot be entered in that manner unless you want a "text" time in which
case type an apostrophe then 0800.

For a real time enter as 8:00 for AM or 16:00 for PM


Gord Dibben MS Excel MVP

On Tue, 15 Aug 2006 07:11:02 -0700, Dell wrote:

I have an excel 2000 spreadsheet that is altering the format of my numbers. I
have changed the format several times but it does not matter it always
changes the format back to another setting. For example when i type in a
whole number it is changed to a decimal. I type in a number like 0800 for
time and it changes it to a zip code for Portugal. I have checked the
options and custom settings, the cell format settings and everywhere else but
no luck.

Any help or suggestions would be greatly appreciated.

Thanks,
Dell

Ah, problem solved for the decimals in my zip codes! Thank you!

"Gord Dibben" wrote:

First problem......

ToolsOptionsEdit. Uncheck "fixed decimal places"

Second problem...........

Times cannot be entered in that manner unless you want a "text" time in which
case type an apostrophe then 0800.

For a real time enter as 8:00 for AM or 16:00 for PM


Gord Dibben MS Excel MVP

On Tue, 15 Aug 2006 07:11:02 -0700, Dell wrote:

I have an excel 2000 spreadsheet that is altering the format of my numbers. I
have changed the format several times but it does not matter it always
changes the format back to another setting. For example when i type in a
whole number it is changed to a decimal. I type in a number like 0800 for
time and it changes it to a zip code for Portugal. I have checked the
options and custom settings, the cell format settings and everywhere else but
no luck.

Any help or suggestions would be greatly appreciated.

Thanks,
Dell