Hi Sam,

You could use the following formula and then copy/paste values:

=TEXT(A1,"0000.00")

Regards,
KL


"Sam" wrote in message
...
Hi,

I have a problem with leading zeros and decimal points.

The data looks like this:

176.87
25
657.9
6667.09
56.56
5.9


The data should look like this:

XXXX.XX

0176.87
0025.00
0657.90
6667.09
0056.56
0005.90

I'm able to use the custom numbers to get this result but it can't be
transfered anywhere, and the program still sees the original data.

I figure changing it to text might make a difference but I'm unsure
how. Any help appreciated.

Thanks,
Sam