How to STOP Excel from changing my data

G

google

Hi,

I'm working in Microsoft Excel Mac version.

I need to enter '3E11'in a cell. But it keeps changing it to 3E+11 or 300000000000.

I've Googled and changed settings to manual etc. But it keeps changing. Anyone who knows how to fix this?

Thanks.
 
C

Claus Busch

Hi,

Am Tue, 27 May 2014 01:45:55 -0700 (PDT) schrieb (e-mail address removed):
I need to enter '3E11'in a cell. But it keeps changing it to 3E+11 or 300000000000.
Click to expand...

format the cells as Text before entering the value or write an
apostrophe in front of your value:
'3E11


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stop XL from changing format? 1
How do I stop Excel from replacing "(c)" with copyright symbol? 2
How do I stop excel from changing my ratios into time format? 3
why does excel keep defaulting to manual calculation? 2
how to force excel not to change date? 2
how do i stop the auto format on excel? 2
how do i stop autocorrecting the date? 2
Excel Stop Excel from displaying rounded values 4

Top