View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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