| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I stop excel from auto formula, ie 48E69 makes 48.0e+70?
I am making a list of general numbers and excel keeps making a formula out of
anything with an E in it, example 48E69 turns into 48.0E+70. I can't figure out how to stop this from happening and I have about 100 parts with an E in them. Help someone! Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I stop excel from auto formula, ie 48E69 makes 48.0e+70?
Pre-format the cells as text or pre-fix the entry with a leading apostrophe
'. It will stop this and won't show -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "metaylor" wrote in message ... I am making a list of general numbers and excel keeps making a formula out of anything with an E in it, example 48E69 turns into 48.0E+70. I can't figure out how to stop this from happening and I have about 100 parts with an E in them. Help someone! Thanks, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I stop excel from auto formula, ie 48E69 makes 48.0e+70?
Format the cells as text or put a single quote (') in front of the "number"
before you enter it. Regards Trevor "metaylor" wrote in message ... I am making a list of general numbers and excel keeps making a formula out of anything with an E in it, example 48E69 turns into 48.0E+70. I can't figure out how to stop this from happening and I have about 100 parts with an E in them. Help someone! Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| what is a formula | Excel Worksheet Functions | |||
| Excel Formula Issue | Excel Discussion (Misc queries) | |||
| Why would Excel stop auto text for one word only | Excel Discussion (Misc queries) | |||
| How do I make a name formula auto update in Excel | Excel Worksheet Functions | |||
Hybrid Mode
