Excel Data Format

  • Thread starter Thread starter Navin
  • Start date Start date
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
 
Hi Navin.

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

You could try importing the relevant data as text.
 
Export the information with a leading single quote. This ensures Exce
will read the information as text and should clear up your problem.
piku
 
Back
Top