Previous Topic Next Topic

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 reply

Answer 1 / 1
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