Convering text to numbers

Closed
sona - Jul 1, 2009 at 07:01 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 1, 2009 at 08:38 AM
Hello,

i downloaded numbers from database. it was 17 digit long numbers. when i paste in excel the last 2 digit gets convert into zero. what i do i don't know.
Related:

1 response

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 1, 2009 at 08:38 AM
Hi sona

If you want to display the number as text just format the cells as TEXT and then paste the 17 digit numbers
0