View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default end a number in ZERO

How about using a numberformat of:

0000.0000
or
0000,0000

Depending on what your decimal character is.

Teri Yaki wrote:

How can I end a number in zero without an apostrophe or entering as text?
When I enter a number (ie: 6310.5130) the last zero doesn't show in the
cell, only in the formula bar. If I enter it as a number, it adds commas.
--
Teri


--

Dave Peterson