Excel Data Format
 

I have data in my database that contains the following value

01244320677,01244320686,01244320727,01244320762,01 244314619

but when i export in excel
the column shows the following data
124,432,067,701,244,000,000,000,000,000,000,000,00 0,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

Excel Data Format
 

Hi Navin.

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

You could try importing the relevant data as text.


---
Regards,
Norman



"Navin" wrote in message
m...
I have data in my database that contains the following value

01244320677,01244320686,01244320727,01244320762,01 244314619

but when i export in excel
the column shows the following data
124,432,067,701,244,000,000,000,000,000,000,000,00 0,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

Excel Data Format
 

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

--
Message posted from http://www.ExcelForum.com