Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Formatting
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. |
#2
|
|||
|
|||
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 "Erika" wrote: 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. |
#3
|
|||
|
|||
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? "IanRoy" wrote: 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 "Erika" wrote: 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. |
#4
|
|||
|
|||
Erika
Do you mean if you type 123 in a cell it comes up as 1.23? ToolsOptionsEdit. Uncheck "fixed decimal places". Gord Dibben Excel MVP On Tue, 11 Jan 2005 06:41:03 -0800, "Erika" wrote: 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. |
#5
|
|||
|
|||
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 "Erika" wrote: 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? "IanRoy" wrote: 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 "Erika" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Date formatting in Excel | Excel Discussion (Misc queries) | |||
Help needed with textbox formatting in Excel 2000 | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Excel formatting of text-- one cell needed | Excel Discussion (Misc queries) |