Question #9350118

Stop Excel from auto formating?

Iam using excel 07 and it is automatically formatting numbers which is driving me crazy. I have to add a special designation number into a cell and the numbers are formatted like this, ##E##. Well exel thinks I am trying to use exponents or something since I am using an "E" so it is trying to be useful and changes the number format to scientific. Well I am not doing that the number is supposed to be for example 52E3 but excel changes it too 5.20E+04. How do I fix this?

2013-08-08 14:49:11

TELL US , if you have any answer

There is NEVER a problem, ONLY a challange!

The is a free-to-use knowledgebase.
  The was started on: 02.07.2010.
  It's free to register. Once you are a registered user, you can ask questions, or answer them.
  (Unless registration you can just answer the questions anonymously)
  Only english!!! Questions and answers in other languages will be deleted!!

Cheers: the PixelFighters


C'mon... follow us!

Made by, history, ect.