• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Text Number rounding problem

Dear Friends,

I have an number data in excel sheet here I want to copy the same to another excel sheet as a text numbers. When I am trying to do the same it is covering text by rounding the numbers. For example if original number is 81 text number is appearing as 80 in new excel sheet as a result mismatching the data

Hence,kindly help me how can resolve the same.

attached excel sheet herewith for your kind support.

Thanks,
Kumar
 

Attachments

  • for Exel Help.xlsx
    14.1 KB · Views: 0
Hi:

The no. of digits in your numbers are more than 15, excel changes any digits after the fifteenth place to zeroes,it stores only 15 digits in a number. The only workaround available is to leave it as text.

Thanks
 
There is no solution to this. If the number is greater than 15 digits then you have to keep it as text if you want to see the whole number
 
Back
Top