View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Newbee Newbee is offline
external usenet poster
 
Posts: 33
Default 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