How to stop last number from changing to 0

G

Guest

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!!!
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation? 2
2nd and 3rd last number in a column - how to get it? 4
long number ends in 000 2
Format cell to Number 14
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
16 digit number entry changes last digit to 0 1
Pasted values that paste as "number stored as text" 3
"Bug" in number format for long number entries? 7

Top