View Single Post
  #1   Report Post  
loudfish
 
Posts: n/a
Default

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