Home |
Search |
Today's Posts |
#1
|
|||
|
|||
the use of e in Excel
I have a series of part numbers that include the letter e. ( EX: 38E275 )
Excel is treating these as Exponents (I thnk) and I see the value changed into scientific notation. I know that I can change the formatting in the cell to text and it works properly but...Is there a way that I can get excel to stop treating "e" as an exponent for the whole sheet w/o changing all of my numbers to text. Thank you for your help and advice |
#2
|
|||
|
|||
Format the cells as TEXT then enter your part identifications.
"john mcmichael" wrote in message ... I have a series of part numbers that include the letter e. ( EX: 38E275 ) Excel is treating these as Exponents (I thnk) and I see the value changed into scientific notation. I know that I can change the formatting in the cell to text and it works properly but...Is there a way that I can get excel to stop treating "e" as an exponent for the whole sheet w/o changing all of my numbers to text. Thank you for your help and advice |
#3
|
|||
|
|||
I think the best you can do is either preformatting the cell as text or starting
the value with an apostrophe: '38E275 (Excel will see the apostrophe and know that you want the value treated as text.) john mcmichael wrote: I have a series of part numbers that include the letter e. ( EX: 38E275 ) Excel is treating these as Exponents (I thnk) and I see the value changed into scientific notation. I know that I can change the formatting in the cell to text and it works properly but...Is there a way that I can get excel to stop treating "e" as an exponent for the whole sheet w/o changing all of my numbers to text. Thank you for your help and advice -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |