Format Numbers Without Fixed Decimal

[Guest]

How do I format a number as in 1,2,3,4,5,6 without zeros or decimals? I tried
the General but I get 0.01 instead of 1

I am using Office 2007.

 

[Guest]

Format the cells in question as text....

 

[Guest]

Thanks for a quick response. The "Text Format" works fine.

 

[Gord Dibben]

I suspect you have Tools>Options>Edit "Fixed decimal places" with 2 DP enabled.

This will change 1 to .01 or 10 to 1

Uncheck this feature.


Gord Dibben MS Excel MVP

 

[Bernard Liengme]

I think you have set the option to make all numbers have two decimal places.
Click the Office button; open Excel options and look around - my XL2007
computer is asleep and I cannot recall the exact location of this setting
If you type 1 and get 0.01 then this is your solution!
best wishes

 

[Guest]

I had the same problem and didn't like using text for numbers.Excel 2007 does
not have Tools>Options>Edit like previous versions.
Instead use:
Office Button>Excel Options>Advanced Tab>Editing Options
section>Automatically insert a decimal point = uncheck.