Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop Excel converting csv values to scientific format
Hi - we have a data supply that delivers a csv file as the output and we want
to cut and paste the csv content into an Excel sheet. In this csv file is one column that contains an alphanumeric value. The problem is when the number happens to end in E03 (for example) Excel thinks this is a scientific notation and puts three zeros at the end of the value - which now makes the value wrong. We tried formatting the Excel spreadsheet column to be text only - but it appears that the problem is occuring when Excel opens the csv file and NOT when we enter the data into the Excel file. How can I prevent this happening please? Is there a different way of opening the csv file? Many thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Hexadecimal being converted wrongly to scientific? | Excel Discussion (Misc queries) | |||
Scientific Formatting takes over - how to stop... | Excel Discussion (Misc queries) | |||
Stop scientific format | Excel Discussion (Misc queries) | |||
csv converting numbers to scientific format | Excel Discussion (Misc queries) | |||
Stop Excel from converting text labels in CSV files to Values | Excel Discussion (Misc queries) |