Excel Data Format

N

Navin

I have data in my database that contains the following value

01244320677,01244320686,01244320727,01244320762,01244314619

but when i export in excel
the column shows the following data
124,432,067,701,244,000,000,000,000,000,000,000,000,000,000,000,000,000

It strips the leading zero and changes the format of the data

how can i retain my orginal data in excel while exporting.

Guys please help me out.
Regards
Navin Mahindroo
 
N

Norman Jones

Hi Navin.

Excel only handles15 digits of precision. Subsequent digits are replaced
with zeros.

You could try importing the relevant data as text.
 
P

pikus

Export the information with a leading single quote. This ensures Exce
will read the information as text and should clear up your problem.
piku
 
Top