[Date Prev][Date Next][Thread Prev][Thread Next]
[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.
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