View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I force trailing zeros in an Excel cell?

It's the preformatting of the cells that keeps the trailing (and leading 0's??).

But you could use a formula like this in a helper column of cells:
=text(a1,"0000.00000")
and copy down.

Then edit|copy
and edit|paste special|values over the original range
and then delete that helper column.

And I'd format that column as Text just so the next change doesn't screw things
up.



Tony C wrote:

My accounting people have set up an excel spread sheet. woth part numbers.
Many of them end in a "0". Ex; 2211.11520
and if you click on a cell with a number ending in 0 , the zero goes away on
the edit line.
When I copy and past this numeric column into other Excels or import into
other applications the Trailing 0 is gone. Any one out there know a way I can
convert or format or save this column and it will keep the trailing zeros,
Note: when I convert the column from a number to text the trailing zeros
drop off.
Help!


--

Dave Peterson