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