I have an issue when creating a text csv file that is then opened in Excel. One such character field when seen by Excel is displayed as exponent whenever there are only numbers in the string--if even just one letter it will display correctly.
I can format the cells then in Excel 2003 as numeric with 0 decimals and the string will display but here is where the larger issue manifests itself...the last 3 characters become 0's irrespective of what they originally were--not good !! I have tried double-quoting them prior to opening in Excel but it makes no difference.
I am hoping someone else has experienced this...but even if not any suggestions as to possible ways to open this file with Excel and maintain the string would be great.
A small example of a string would be:
When saved as a .CSV file and then opened in Excel 2003, you will see that 2 have been converted to exponent (the ones without any letter, only digits). Formatting the cell to numeric without decimal changes the last 3 characters to 0s so this is not a remedy.
This particular field happens to be a linking field that will be used even after exporting as a csv file so I cannot add a letter---I will have to actually ask about that as that may be an alternative. I will have to find out exactly how it is to be used after the fact--the specs say it cannot be....but hey, never say never right! But would rather oblige them than have them make an exception if possible.
Anything to try would be great! :)
I can format the cells then in Excel 2003 as numeric with 0 decimals and the string will display but here is where the larger issue manifests itself...the last 3 characters become 0's irrespective of what they originally were--not good !! I have tried double-quoting them prior to opening in Excel but it makes no difference.
I am hoping someone else has experienced this...but even if not any suggestions as to possible ways to open this file with Excel and maintain the string would be great.
A small example of a string would be:
Code:
D,999999999,"8000062E1244050917",Displays Correctly D,999999999,"800007644264008809",Exponent_last 3 characters should be 809 D,999999999,"10C00001132078339",Displays Correctly D,999999999,"22A00001141678279",Displays Correctly D,999999999,"800005241207937686",Exponent_last 3 characters should be 686
This particular field happens to be a linking field that will be used even after exporting as a csv file so I cannot add a letter---I will have to actually ask about that as that may be an alternative. I will have to find out exactly how it is to be used after the fact--the specs say it cannot be....but hey, never say never right! But would rather oblige them than have them make an exception if possible.
Anything to try would be great! :)
Comment