| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Excel Changing Format | Excel Worksheet Functions | |||
| stop excel changing formulas | Excel Discussion (Misc queries) | |||
| How can I stop charts from refreshing when changing source data? | Charts and Charting in Excel | |||
| How do I stop last number from changing to a 0 in excel | Excel Discussion (Misc queries) | |||
| stop changing data to date | New Users to Excel | |||
Linear Mode
