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
Never mind the 0.0 is not working. I am going to stick with the first one.
the 0,.# It works the best "Jim Thomlinson" wrote: Sorry I got that kinda backwards and plain old fashioned wrong... Try this custom format... 0.0, -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: 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
This works too. I can now see the 0's on large numbers. at first it was
showing 1. and leaving off the 0 now it shows the complete 1.0 Thanks. "Jim Thomlinson" wrote: Sorry I got that kinda backwards and plain old fashioned wrong... Try this custom format... 0.0, -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers displayed in the 100th decimal instead on 1,000
Not sure how this works but it is working GREAT!!!!
Thank you very much! "Jim Thomlinson" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers displayed in the 100th decimal instead on 1,000
Sorry I got that kinda backwards and plain old fashioned wrong... Try this
custom format... 0.0, -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: 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 |
#6
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 |
#7
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) |