nischal4487
New Member
 Joined
 Nov 21, 2007
 Messages
 30
Hi,
I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as 1.80205E+11 . I understand I can do the paste special while pasting it , however, I cannot ask my client who uses the same sheet to do so everytime.Please let know if there is any format that i can change in the excel so when i paste the number, the actual number appears.
Many Thanks,
Nik
I am trying to paste a number 180204524303 from an email to an excel cell, however, whenever i try to do so , the the paste value appears as 1.80205E+11 . I understand I can do the paste special while pasting it , however, I cannot ask my client who uses the same sheet to do so everytime.Please let know if there is any format that i can change in the excel so when i paste the number, the actual number appears.

Many Thanks,
Nik