Cell Format keeps on changing

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

Guest

When I enter 0e001 in a cell in MS Excel 97, the cell changes to 0.00E+00 where it should remain 0e001. If you replace the e and enter any other letter this remains in the cell as 0a001

I need the cell format to remain as general and I need to add the e in (0e001)

Can anyone help please. Thank You
 
Hi
reason for this is that Excel interprets this entry as a number entered
in scientific format. One workaround if you can't change the cell
format: Precede your entry with an apostrophe. e.g.
'0e001
 
I have to keep the cell as genera

Regards
"H
----- Frank Kabel wrote: ----

H
preformat the cell as 'Text

-
Regard
Frank Kabe
Frankfurt, German


H wrote
 
Back
Top