Cell Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks again.
Any idea what this one is doing and how to fix it?

I insert 90014E04 and Excel converts it to a scientific
number 9.00E+08

Any idea what the formula would be to convert this back?
 
Hi
the value 90014E04 is a valid number for Excel. Two possible
workarounds (if this should be a text):
- format the cell as 'Text' prior to entering
- preced the value with an apostropeh: '90014E04
 
Back
Top