| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
how can I enter a 21 digit number in a cell & keep it from change
Alex, if you don't need to do any math with it format the cell as text
before you put the number in or put an ', apostrophe, in front of it -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "alex" wrote in message ... What changes should i make to my set up if I need to be able to enter a number into a cell that is 20 or more digits long & I want to keep it from changing to scientific notation (as it does when a number is more than 12 digits long)? Excel 2003 professional edition |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how change number in cell to text | Excel Discussion (Misc queries) | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) | |||
Threaded Mode
