Hi Sam,
You could use the following formula and then copy/paste values:
=TEXT(A1,"0000.00")
Regards,
KL
"Sam" <[email protected]> wrote in message
news:[email protected]...
> 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
Bookmarks