Number formatting

  • Thread starter Thread starter jag
  • Start date Start date
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
 
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
 
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.
 
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
 
Hi,

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