Thread: How to STOP Excel from changing my data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default 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
Reply With QuoteReply With Quote