| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop last number from changing to 0
HELP PLEASE!!!
I'm using excel 2000 and when ever i paste a number that is longer than 15 numbers the last number is changed to 0. If i type that same number the last numer will be whatever number i typed. It only seems to change whenever i paste the number. Even if i do paste special and choose text the last number is still 0 or if i just delete the 0 and type the last number in it still changes to the 0 even when the cell is formatted for text. If anyone has any suggestions i would greatly appreciate it. Thanks!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to stop last number from changing to 0
Save your hair.
Format the cell as Text before entering the value or precede the number with an apostrophe (single quote) Excel only handles 15 digit values. -- Gary''s Student - gsnu200755 "Pulling My Hair" wrote: HELP PLEASE!!! I'm using excel 2000 and when ever i paste a number that is longer than 15 numbers the last number is changed to 0. If i type that same number the last numer will be whatever number i typed. It only seems to change whenever i paste the number. Even if i do paste special and choose text the last number is still 0 or if i just delete the 0 and type the last number in it still changes to the 0 even when the cell is formatted for text. If anyone has any suggestions i would greatly appreciate it. Thanks!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop Excel from changing last digit in a number entry? | New Users to Excel | |||
| stop changing my formula | Excel Worksheet Functions | |||
| How do I stop last number from changing to a 0 in excel | Excel Discussion (Misc queries) | |||
| How do I stop 5/6 changing to 5/6/05? | Excel Discussion (Misc queries) | |||
| stop number font size from changing each time i click on somethin. | Charts and Charting in Excel | |||
Linear Mode
