How to STOP Excel from changing my data
 

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.

How to STOP Excel from changing my data
 

Hi,

Am Tue, 27 May 2014 01:45:55 -0700 (PDT) schrieb :

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

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


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional