Re: Preceding Zeros...

From: Brian (treddderx_at_yahoo.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 09:29:24 -0600

Thanks Frank, works like a charm!

"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:eXKdOne4EHA.1392@tk2msftngp13.phx.gbl...
> Hi
> you could use a helper column with a formula such as
> =TEXT(A1,"0000000000")
> and import this column
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> Brian wrote:
>> Situation: I have an application that looks at an excel spread***
>> as a database and pulls account number and account name from the
>> work***.
>> The account numbers range from 5 digits to 10 digits so I need to
>> display all of the numbers as 10 digits. So I have formatted the
>> cells to display ten digits (0000000000).
>>
>> Problem: When my application pulls the numbers, it does not show the
>> preceding zeros like I need it to.
>> When I look at the work***, the zeroes are displayed, but when I
>> highlight a cell, the displayed value in the upper left corner box
>> (don't know the proper name for it) does not show the zeroes.
>>
>> Any ideas how to get these zeroes to be permanent?
>>
>> Thanks for you time and attention.
>>
>> Any suggests
>
>