How to stop last number from changing to 0

  • Thread starter Thread starter Guest
  • Start date Start date
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!!!
 
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

sum last 3 numbers greater that 0 in a range 0
long number ends in 000 2
excel changes the last number I type in column??? 5
Why does excel replace my 16th number with a zero? 2
16 digit number entry changes last digit to 0 1
Changing Text To Numbers ? 1
NEED HELP..CONVERT NUMBERS BACK TO TEXT 6
Custom Format on 16 Digit Number 5

Back
Top