| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to save excel data into dbf format? | Excel Discussion (Misc queries) | |||
| Importing Data from Excel when data not in same format | Excel Discussion (Misc queries) | |||
| Format Data from Excel to word | Excel Discussion (Misc queries) | |||
| format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
| How do I put Excel data into a US map format? | Charts and Charting in Excel | |||
Linear Mode
