Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
We have data that is downloaded to a .xls file from a SAP application. The field in question is a 30 character field that contains all numeric data. The problem is when opened in Excel the format of the data is change to scientific notation and the right 7 characters are changed to zeros. The character string should be 9611019049526870545643 but in Excel it appears as 9.61102e+21 and formated as a general number. When converted to a displayable number it converts to 9611019049526870000000. I tried saving the file rather than opening it into Excel and found the character string did contain all the numbers, when opening it in Notepad it appears as <td class='SAPBExSt' style=" " 9611019049526870545643 </td. Any assistance would be appreciated. Thanks, Rick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting issue | Excel Discussion (Misc queries) | |||
Formatting issue ??? | Excel Discussion (Misc queries) | |||
Cell formatting issue | Excel Discussion (Misc queries) | |||
formatting issue? | Excel Discussion (Misc queries) | |||
Formatting issue | Excel Worksheet Functions |