Leading Zeros and decimal points
 

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

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

or just use a custom format of '0000.00' if it just how it looks that
matters, as KL's method changes it to text.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KL" wrote in message
...
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

On Tue, 12 Jul 2005 02:05:37 +0200, "KL"
wrote:

Hi Sam,

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

=TEXT(A1,"0000.00")


Thank you.

Sam

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