Sir,
Please find attached the file. the numbers in the cell formatted as text i could not add those nos with other nos if i do it shows error like #VALUE.
how do rectify the error? how do convert that to Number format?..
Please help on this issue.
Regards,
R.Sathyamoorthy.Excel Problem.xlsx
In a black cell, write 0.
Copy that cell.
Now select the complete area.. then Paste Special > In Operation section Select > ADD..
Press OK..
[img]30-11-2014 16-22-46.jpg[/img]
Will resolve your problem.. of conversion..
Last edited by Debraj Roy; 11-30-2014 at 06:58 AM.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
I just did a find "," and replace [left blank] - did a replace all and it seemed to work and it kept the format.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sir,
That also showing the Same Result.
Please help me on this
Regards,
R.Sathyamoorthy
Sir,
Thank You very much. now it works.
Regards,
R.Sathyamoorthy.... Shift+R improves the quality of this image. CTRL+F5 reloads the whole page.
if you are referring to my "solution" here is your original sheet attached again with the results of my find and replace.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks