Coma Separator in Excel to Format Number as 1,00,000.00
This query is : Resolved
13 April 2008
By default the coma separator in excel is placed on every 000 (1,000,000.00) but in India we use it first after 000 then after every 00 - like 1,00,00,000.00. Can this format be made/programmed? How?
13 November 2008
Select the range you want to change in Indian Comma Style and
goto format menu> number tab > custom
Enter following and save
[>9999999]"Rs."##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs."##,##0
**DM
goto format menu> number tab > custom
Enter following and save
[>9999999]"Rs."##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs."##,##0
**DM
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
- Tax on Deemed Capital Gain
- Exiting partner in partnership firm in gst portal
- Type of Capital Gain
- Grand in aid
- ASMT-10 received from A O
- IT returns for fresh job holders
- ITR-Capital Gain
- Traces submitting correction statement error
- Technical Glitch in ITR-4 Online Form (AY 2026-27): Sec 44AE Partner Remuneration not mapping to E8
- Residential status of non resident
- CASH GIFT FROM BLOOD RELATIVE
- Account freezed for Ineligible ITC Scrutiny for GST Annual Return
- Rent claimed on building given on permissive possession basis
- TDS on property - Form 141 query
- Seeking Advice: High Tax Shortfall on Job Switch + Let-Out House Property Loss in FY 2025-26
- Housing Society-ITR5
- TDS on Rent received on redevelopment of building
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- Upload Level ValidationITR3Category of Defect B/D
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
