Thread
:
WHY DOES 1E4 TURN INTO 1.00 E + 04? THANKS
View Single Post
#
1
loudfish
Posts: n/a
1e4 is recognised as scientific notation for numbers in excel. To force
text:
a. have the cell pre-formatted as "text" (Format...Cells... on the
menus).
or
b. put a single quote at the start. '1e4 instead of just 1e4
Best
Andrew
Reply With Quote