Number formatting

J

jag

i type "2" and it automatically converts to ".02". I do not want
this. Any idea what I did to get this and how do I get my old excel
back?
Thanks in advance
 
T

That One Guy

This is a new one for me. It sounds like you are somehow converting a
percentage to a decimal.

2.00% 0.02

If that's not the case, than I'm not aware of any other number format
that automatically divides a number by 100. Maybe it's something build
into Excel 2007 (I'm on 2003). Try messing with the number formats for
all your data if you're entering directly into Excel.

Regards,

That One Guy
 
J

jag

This is a new one for me.  It sounds like you are somehow converting a
percentage to a decimal.

2.00%           0.02

If that's not the case, than I'm not aware of any other number format
that automatically divides a number by 100.  Maybe it's something build
into Excel 2007 (I'm on 2003).  Try messing with the number formats for
all your data if you're entering directly into Excel.

Regards,

That One Guy




- Show quoted text -
Click to expand...

Yeah, on 2007. i checked all the formating defaults and they seem
ok. It's wierd!
Thanks for the response.
 
J

jag

Hi

Tools>Options>Edit>uncheck>Fixed Decimal places

--
Regards
Roger Govier






- Show quoted text -
Click to expand...

Fantastic, thank you, tools and fixed decimals it was! Problem solved
 
S

Shane Devenshire

Hi,

In 2007 the command would be Office Button, Excel Options, Advanced, and
uncheck Automatically insert a decimal point...
 
Top