| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers displayed in the 100th decimal instead on 1,000
I am trying to get my numbers to be desplayed in decimal format instead on
number. How do I do that? For example: 14,000 to be desplayed as 14.0 or 125,500 to be displayed as 125.5 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers displayed in the 100th decimal instead on 1,000
Format the cell with the the custom format (Format - Format Cell - Number
- Custom) 0,.# -- HTH... Jim Thomlinson "Newbee" wrote: I am trying to get my numbers to be desplayed in decimal format instead on number. How do I do that? For example: 14,000 to be desplayed as 14.0 or 125,500 to be displayed as 125.5 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers displayed in the 100th decimal instead on 1,000
If you are saying there is confusion between commas and full stop signs for
decimal points and thousands separators, look at your Windows Regional Options. Or is your number actually being shown correctly in the formula box, & just needing to be formatted differently? -- David Biddulph "Newbee" wrote in message ... I am trying to get my numbers to be desplayed in decimal format instead on number. How do I do that? For example: 14,000 to be desplayed as 14.0 or 125,500 to be displayed as 125.5 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Automaticallychanging the number of decimal places displayed | Excel Discussion (Misc queries) | |||
| elapsed time displayed as a decimal | Excel Worksheet Functions | |||
| How do I change the number of decimal places displayed in Excel | Excel Discussion (Misc queries) | |||
| How do I stop Excel from changing simple numbers to their 1/100th. | Excel Discussion (Misc queries) | |||
Hybrid Mode
