Leading Zeros and decimal points

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

On Tue, 12 Jul 2005 02:05:37 +0200, "KL"
<[email protected]> wrote:

>Hi Sam,
>
>You could use the following formula and then copy/paste values:
>
>=TEXT(A1,"0000.00")


Thank you.

Sam

>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
>

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

On Tue, 12 Jul 2005 02:05:37 +0200, "KL"
<[email protected]> wrote:

>Hi Sam,
>
>You could use the following formula and then copy/paste values:
>
>=TEXT(A1,"0000.00")


Thank you.

Sam

>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
>

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" <[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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

On Tue, 12 Jul 2005 02:05:37 +0200, "KL"
<[email protected]> wrote:

>Hi Sam,
>
>You could use the following formula and then copy/paste values:
>
>=TEXT(A1,"0000.00")


Thank you.

Sam

>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
>