In the ID column of the attached excel file whenever I convert the numbers stored as text to numbers it results in a weird transformation.
e.g. an ID of 480610141001 becomes 4.8061E+11. When I do the same process in the name column, which has similar numbers, it will give the correct result following the same process.
Help would be greatly appreciated.
Last edited by cmf0106; 10-22-2009 at 02:53 PM.
Right click on the cell.
Format cell
Number tab
Choose Number, choose 0 decimal places
Didn't happen to me...
... but you can try selecting the column and formatting the cells as Number with no decimals.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks