How to remove commas & decimal in numbers
This query is : Resolved
07 January 2016
Hi All
how to remove commas & decimal in numbers for e.g. 45,230.55 should be 45231/- ??????
thnx
preet
how to remove commas & decimal in numbers for e.g. 45,230.55 should be 45231/- ??????
thnx
preet
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.
08 January 2016
i have tried the way u have replied but it doesn't work !!!!!!!!!!!
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
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Is this income indian or foreign income?
- ITC temporary reversal and reclaim
- Applicable TDS rate for sale of property in Nov 2024
- Inventory of finished goods
- Quiery in relation to GST liability in case of an advocate who has obtained GST registration.
- Tds on building rent monthly
- RCM INVOICING FROM NOV-2024
- GST Regis.
- Sale of property furniture sale
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- COP Surrender 2024
- Regarding Waiver of Interest levied u/s 50 of PGST/CGST Act
- LAST YEAR 2022-23 ITC IN NEXT YEAR 2023-24 REPORITNG IN GSTR-9
- MIS MATCH OF INVOICE NUMBER
- IGST Credit-Show cause notice issued-confusion
- Issue of gst e invoice
- How to adjusted advances given or receipt
- Foreign vendor without PAN unable to to register due to non receipt of OTP on foreign number ?
- 133(6) DIN INVALID format error - ->WHERE TO REPLY 133(6) notice?
- Query for dubts
Trending Online Classes
CAclubindia
