How to remove commas & decimal in numbers

This query is : Resolved

preet prakash (Querist)
Follow

07 January 2016 Hi All
how to remove commas & decimal in numbers for e.g. 45,230.55 should be 45231/- ??????

thnx
preet

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

07 January 2016 Select the cell. Right Click and go to Format Cell option. Under the Number option uncheck the Use separator(,) option. For removing decimal use decrease decimal option.

preet prakash

preet prakash (Querist)
Follow

08 January 2016 i have tried the way u have replied but it doesn't work !!!!!!!!!!!

CMA. CS. Sanjay Gupta

CMA. CS. Sanjay Gupta (Expert)
Follow

09 January 2016 It has to work unless the comma are in text form. If it is in text form try find and replace option...Find (,) Replace with (leave Blanck)....and then replace all...

Message likes : 1 times