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
- Is this income indian or foreign income?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- ITC temporary reversal and reclaim
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- TDS U/S. 194NF
- GST on export of services and Input Credit
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- Applicable TDS rate for sale of property in Nov 2024
- REGARDING 25 AS DATE OF PAYMENT AND DATE OF BOOKING
- Import license renewal
- Inventory of finished goods
- 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
- Regarding einvoice taken on nil rated sales
Trending Online Classes
CAclubindia
