banner_ad

Coma Separator in Excel to Format Number as 1,00,000.00

This query is : Resolved 
Profile Image

Profile Image

(Querist)
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?
Profile Image

CA. Dashrath Maheshwari

Profile Image

CA. Dashrath Maheshwari (Expert)
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
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
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details
Company
19 May 2026
Article, CA & Paid Assistant Positions

Aggarwal Sarawagi and Co

New Delhi

CA

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details