Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Disable Scientific Notation conversion
I need to turn-off a function in Excel that causes text data to be converted
to numbers in Scientific Notation form. I don't want my text file that contains text to be automatically converted. Example: 83E2 will be converted to 8.30+E3. I want it to open with 83E2 only. -- Client Server Developer |
#2
|
|||
|
|||
Do you have control of how the text file gets made? If so specify a single
quote in front of this field then Excel will read text. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Clark G." wrote in message ... I need to turn-off a function in Excel that causes text data to be converted to numbers in Scientific Notation form. I don't want my text file that contains text to be automatically converted. Example: 83E2 will be converted to 8.30+E3. I want it to open with 83E2 only. -- Client Server Developer |
#3
|
|||
|
|||
or you could use the OpenText Method in your import procedure and code in
which fields you want to be text. HTH, Gary Brown "Clark G." wrote: I need to turn-off a function in Excel that causes text data to be converted to numbers in Scientific Notation form. I don't want my text file that contains text to be automatically converted. Example: 83E2 will be converted to 8.30+E3. I want it to open with 83E2 only. -- Client Server Developer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Truncate scientific notation | Excel Worksheet Functions | |||
Scientific notation | Excel Discussion (Misc queries) | |||
Removing Scientific Notation | New Users to Excel | |||
convert scientific notation to a number | Excel Discussion (Misc queries) | |||
Disable automatic date conversion feature | Excel Worksheet Functions |