[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: .lis file to Excel
Excel will preserve the leading zeroes if its in the format ="06514" but Im
not sure if you would like this same format to appear in your .lis file.
-Emil
Mario Mendoza wrote:
> Does anyone know how to format a tab delimited .lis file so Excel will not
> omit leading zeroes (0)?
>
> The zip code information on the .lis file is correct i.e. 06514, however,
> when the file is opened through Excel, the zip code is 6514.
>
> Thank you for any guidance.
>
> Mario Mendoza
> 1-888-647-6472 x633
> mariom@flagshipcredit.com