Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel converts 9-digit string to sci. not. when saved as csv
When using data in MS Excel, I frequently have a column with length 9 string
of all digits. If I want to export to Access or save as a *.csv, Excel converts this to scientific notation and it cannot be converted back to the original data. I often have rows of 1100 or more, so manually entering a single quotation mark at the beginning of each cell is out of the question. Is there a way to turn off this conversion to scientific notation? Highlighting the column then nsing FormatCellsText also converts everything to scientific notation |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel converts 9-digit string to sci. not. when saved as csv
If the cell is formatted to General, and the number is too large to fit in
the cell, you'll get that scientific notation. If the cell is *pre*-formatted to Number, your long numbers will either enlarge the column to accept all the digits, OR give you the #### signs. You shouldn't get scientific notation in any case. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "epen" wrote in message ... When using data in MS Excel, I frequently have a column with length 9 string of all digits. If I want to export to Access or save as a *.csv, Excel converts this to scientific notation and it cannot be converted back to the original data. I often have rows of 1100 or more, so manually entering a single quotation mark at the beginning of each cell is out of the question. Is there a way to turn off this conversion to scientific notation? Highlighting the column then nsing FormatCellsText also converts everything to scientific notation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List File Properties - Author | Excel Worksheet Functions | |||
Excel Spreadsheet Not Saved Dialog Error | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel |