| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do i stop automatic decimals after number ex 5280.?
Excel adds a decimal point, even if the number format I use doesn't include a
decimal point. It just doesn't look right to have an integer number like 5280 displayed as 5280. (with a decimal point). Is this a bug in Excel? |
|
#2
|
|||
|
|||
|
If you had a number format like #,##0. you would see this.
FormatStyleNormalModifyNumber. Change to the format of your choice then OK your way out. Note: Styles are a workbook setting. If all your Excel numbers are taking on this #,##0. format, I would suggest you go into Windows Regional and Language Options and check/change your settings there. Gord Dibben Excel MVP On Wed, 16 Mar 2005 15:29:02 -0800, "Frustrated" wrote: Excel adds a decimal point, even if the number format I use doesn't include a decimal point. It just doesn't look right to have an integer number like 5280 displayed as 5280. (with a decimal point). Is this a bug in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop automatic hyperlinks? | Excel Discussion (Misc queries) | |||
| Automatic Invoice Number | Excel Discussion (Misc queries) | |||
| Can I disable this automatic number advance thing? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| How do I stop automatic page breaks in excel | Excel Worksheet Functions | |||
Hybrid Mode
