Excel Formatting

E

Erika

When using excel, if a cell format is set to the general format it still
comes up with decimal places. The only way I can get a number without
decimal places is to first enter it as text and then convert to a number.
 
I

IanRoy

Hi, Erika;
Format> Cells> Number
Reduce decimal places to 0.
No need to convert entries, just format the cells to show data in the format
you want.
Regards,
IanRoy
 
E

Erika

Even if I am entering a zip code - I enter the number in leaving the
formatting at general and it still adds a decimal. This is on all new
spreadsheets - I don't remember this happening before? Is there a Normal.dot
(like in Word )for Excel that sets up all of your Book1 defaults?
 
G

Gord Dibben

Erika

Do you mean if you type 123 in a cell it comes up as 1.23?

Tools>Options>Edit. Uncheck "fixed decimal places".


Gord Dibben Excel MVP
 
I

IanRoy

Hi, Erika;
If you mean like this: typing 94107 results in 941.07, then go to
Tools> Options> Edit
and un-check "Fixed decimal Places."
For your second question, look in Excel help under "Troubleshooting
templates."
Regards,
IanRoy
 
Top