just format the cell the way you want it to look. format cells, custom on the
number tab, enter 00.00 and apply it to the cells in question.
--


Gary Keramidas
Excel 2003


"Edward DiMarco" <Edward wrote in message
...
Long time reader, first time asker (read: I tried searching but could not
find the answer):
I have cells that have 4 digit numbers (e.g. 0034) and they need to be
formatted to the 00.00 format (end result: 00.34).

The issue is they were imported from an external data source, so all the
numbers are in Excel as text. When they are converted over to numbers, the
zeroes are dropped, so it ends up being 34. When I apply 00.00 formatting,
or =TEXT(A2,"00.00") or the other methods of keeping leading zeroes, the
number is 34.00, because it takes and tacks the number on the front.

Is there a way to convert these to numbers into the 00.00 format?