View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default 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