| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help question so basic I can not find answer
When I type in 16 or more numbers in a cell it always turns the last one to a 0 and even when I pick the format number it still changes the last number into a o. How can I make excell leave the digital number I type in? -- ed101 ------------------------------------------------------------------------ ed101's Profile: http://www.excelforum.com/member.php...o&userid=25587 View this thread: http://www.excelforum.com/showthread...hreadid=390072 |
|
#2
|
|||
|
|||
|
Excel only keeps track of 16 digits.
So you can either preformat the cell as text or enter your data as text (start with an apostrophe): '1234567890123456. In both of these cases, these "numbers" will be treated as text. ed101 wrote: When I type in 16 or more numbers in a cell it always turns the last one to a 0 and even when I pick the format number it still changes the last number into a o. How can I make excell leave the digital number I type in? -- ed101 ------------------------------------------------------------------------ ed101's Profile: http://www.excelforum.com/member.php...o&userid=25587 View this thread: http://www.excelforum.com/showthread...hreadid=390072 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and replace of word causes change of font formatting | New Users to Excel | |||
| Upgraded to office 2003 now cannot find personal.xls | Excel Discussion (Misc queries) | |||
| How do I find the cell address of the 2nd largest of a set? | Excel Discussion (Misc queries) | |||
| basic pie chart question | Charts and Charting in Excel | |||
| Basic: Looking up Data in Range | Excel Discussion (Misc queries) | |||
Linear Mode
