If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell
I type account number in cell and it turn into 2.50021e+12.
I check the format o cell and it just gernral. The 2.50021e+12 is underline. I not sure wy the cell is doing this. I hoping somebody know what going on. The is Excel 2000. |
#2
|
|||
|
|||
Hi
if your account number consist of numbers and the letter 'E' Excel thinks this is a numeric entry entered in scientific format. Try: - format the cell as 'Text' before entering - or precede the entry with an apostrophe. e.g. '123E23 -- Regards Frank Kabel Frankfurt, Germany wrote: I type account number in cell and it turn into 2.50021e+12. I check the format o cell and it just gernral. The 2.50021e+12 is underline. I not sure wy the cell is doing this. I hoping somebody know what going on. The is Excel 2000. |
#3
|
|||
|
|||
How long is the account number? Excel only shows 15 significant numbers. If
you have an account number larger than this, you need to format the cells you are entering in as text prior to your entering the information into it wrote in message ... : I type account number in cell and it turn into 2.50021e+12. : I check the format o cell and it just gernral. The : 2.50021e+12 is underline. I not sure wy the cell is doing : this. I hoping somebody know what going on. The is Excel : 2000. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a Price calculator | mariekevink | New Users | 2 | September 14th, 2004 05:53 PM |
Can I conditionally UNLOCK a cell? | Chris | Worksheet Functions | 1 | August 31st, 2004 07:47 PM |
using cell contents in pathname | Don Guillett | Worksheet Functions | 7 | January 2nd, 2004 02:11 PM |
Link or paste cells based on Date in cell | Ayanna | Worksheet Functions | 0 | December 16th, 2003 06:10 PM |
Question on LOGIC ?? - PLEASE HELP | PM | Worksheet Functions | 17 | November 28th, 2003 09:13 AM |