banner_ad

How to remove commas & decimal in numbers

This query is : Resolved 
Profile Image

Profile Image

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

thnx
preet

Profile Image

CMA. CS. Sanjay Gupta

Profile Image

CMA. CS. Sanjay Gupta (Expert)
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.
Profile Image

preet prakash

Profile Image

preet prakash (Querist)
08 January 2016 i have tried the way u have replied but it doesn't work !!!!!!!!!!!
Profile Image

CMA. CS. Sanjay Gupta

Profile Image

CMA. CS. Sanjay Gupta (Expert)
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...
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!


Similar Resolved Queries


loading


Unanswered Queries


banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news



Answer Query



Quick Links



Browse by Category




Latest Job Openings

View all
Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
07 June 2026
Tax Associate

Rajkumar Jain & Co.

Ahmedabad

Graduate (Any)

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details