How to stop 12E45 turn into a number?
Posted by ILZE on December 03, 2001 11:34 AM
Is there a way to stop Excel from turning strings with numbers and e into numbers that would work for the whole spreadsheet or file? I have to use strings like 12e56 as codes and I have problems with Excel converting them to meaningless numbers. So far the solution has been to add some punctuation mark at the end of the entry, but I have to get rid of it when using the entry in formulas. I have tried to format the whole column as text, but it didn't work. I don't use scientific notation for numbers, so I would be glad to know how to switch this feature off altogether. I am using Excel98 on Mac.