Disable auto-conversion: decimal number to dates -e.g. 3.8 -> 3-Au

[Harry Nopter]

When I insert a decimal number (e.g. 3.8) in a cell, then it is automatically
shown as a date (e.g. 3-Aug-09), even if I put the number's format (at "cell
format") in the number or in the general format option. I have the 2003
Office. How can I disable this automatic feature?

Thank you!

 

[Laroche J]

Harry Nopter wrote on 2009-04-19 06:21:

When I insert a decimal number (e.g. 3.8) in a cell, then it is automatically
shown as a date (e.g. 3-Aug-09), even if I put the number's format (at "cell
format") in the number or in the general format option. I have the 2003
Office. How can I disable this automatic feature?

Thank you!

In Europe the period is typically used to separate date parts. At the same
time the comma is normally used as a decimal separator. All this is defined
in OS X's International Preferences.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 trial

 

[CyberTaz]

Although JL is correct that this is a Language/Input Method issue rather
than an Excel issue I believe he neglected to notice that you're using a PC
version of the program. Have a look here where you'll find the groups for
the Windows Office [this one is for Office on the Mac]:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Harry Nopter]

You are right, I have a PC. Sorry & Thank you.

Although JL is correct that this is a Language/Input Method issue rather
than an Excel issue I believe he neglected to notice that you're using a PC
version of the program. Have a look here where you'll find the groups for
the Windows Office [this one is for Office on the Mac]:

http://www.microsoft.com/office/community/en-us/FlyoutOverview.mspx

Regards |:>)
Bob Jones
[MVP] Office:Mac

When I insert a decimal number (e.g. 3.8) in a cell, then it is automatically
shown as a date (e.g. 3-Aug-09), even if I put the number's format (at "cell
format") in the number or in the general format option. I have the 2003
Office. How can I disable this automatic feature?

Thank you!