Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel reading pasted values as Scientific Notation
Hello,
My dilemma is as follows: I'm exporting large tab delimited files from SAP for manipulation in Excel. Many of the cost centers for this company are alphanumeric, but often using the letter E, for whatever reason. Example: 000776E0000010. When brought into Excel, it's viewing these as scientific notation and displaying the value as 7.76E+12. Once it's at this point, I can't try to change the cell format to text or general because Excel has already registered the entry as 7760000000000. I've tried copying and paste special as text, it still comes out as the number. Is there any way around this or am I screwed? Many thanks in advance. Brad |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel reading pasted values as Scientific Notation
If you import the file by using the typical open in Excel and use the Text to
Columns feature, when you select your delimiter type, if yu click next, you should also have an opportunity to select individual fields and set their field types. Try changing the one below to Text prior to completing the import. "Brad Autry" wrote: Hello, My dilemma is as follows: I'm exporting large tab delimited files from SAP for manipulation in Excel. Many of the cost centers for this company are alphanumeric, but often using the letter E, for whatever reason. Example: 000776E0000010. When brought into Excel, it's viewing these as scientific notation and displaying the value as 7.76E+12. Once it's at this point, I can't try to change the cell format to text or general because Excel has already registered the entry as 7760000000000. I've tried copying and paste special as text, it still comes out as the number. Is there any way around this or am I screwed? Many thanks in advance. Brad |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel reading pasted values as Scientific Notation
Rename the .csv file to .txt and when you use file|open, you'll see the text to
columns wizard. You'll be able to specify that this field is text. Or keep the .csv file extension and use: Data|import external data|import data (xl2003 menus) You'll see that same text to columns wizard. Brad Autry wrote: Hello, My dilemma is as follows: I'm exporting large tab delimited files from SAP for manipulation in Excel. Many of the cost centers for this company are alphanumeric, but often using the letter E, for whatever reason. Example: 000776E0000010. When brought into Excel, it's viewing these as scientific notation and displaying the value as 7.76E+12. Once it's at this point, I can't try to change the cell format to text or general because Excel has already registered the entry as 7760000000000. I've tried copying and paste special as text, it still comes out as the number. Is there any way around this or am I screwed? Many thanks in advance. Brad -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel display in scientific notation with a 3digit exponent? | Excel Discussion (Misc queries) | |||
Scientific notation-one exponent for all values | Excel Worksheet Functions | |||
Scientific Notation - I want excel to read it as a text not a numb | Excel Discussion (Misc queries) | |||
Excel 2003 won't let me change Xlabels from scientific notation | Charts and Charting in Excel | |||
scientific notation to display 1.8 x 10-5 in Excel | New Users to Excel |