SOLVED

How to write number in Excel in the format 99,99,99,999.99

%3CLINGO-SUB%20id%3D%22lingo-sub-2616003%22%20slang%3D%22en-US%22%3EHow%20to%20write%20number%20in%20Excel%20in%20the%20format%2099%2C99%2C99%2C999.99%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616003%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20write%20number%20in%20Excel%20in%20the%20format%2099%2C99%2C99%2C999.99%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2616003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2616730%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20write%20number%20in%20Excel%20in%20the%20format%2099%2C99%2C99%2C999.99%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2616730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1121481%22%20target%3D%22_blank%22%3E%40KA10900gmail%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20on%20Windows%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EPress%20%3CSTRONG%3EWindow%20key%2BR%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3EType%20%3CSTRONG%3Eintl.cpl%3C%2FSTRONG%3E%20and%20press%20%3CSTRONG%3EEnter%3C%2FSTRONG%3E%20or%20click%20%3CSTRONG%3EOK%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3CLI%3EClick%20%3CSTRONG%3EAdditional%20settings...%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3ESelect%20%3CSTRONG%3E12%2C34%2C56%2C789%3C%2FSTRONG%3E%20from%20the%20%3CSTRONG%3EDigit%20grouping%3C%2FSTRONG%3E%20drop-down.%3C%2FLI%3E%0A%3CLI%3EClick%3CSTRONG%3E%20OK%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F300930iEF55387266721F48%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0650.png%22%20alt%3D%22S0650.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIn%20Excel%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20the%20cells%20that%20you%20want%20to%20format.%3C%2FLI%3E%0A%3CLI%3EPress%20%3CSTRONG%3ECtrl%2B1%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3CLI%3EActivate%20the%20%3CSTRONG%3ENumber%3C%2FSTRONG%3E%20tab.%3C%2FLI%3E%0A%3CLI%3ESelect%20%3CSTRONG%3ENumber%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3CLI%3ESet%20%3CSTRONG%3EDecimal%20places%3C%2FSTRONG%3E%20to%202.%3C%2FLI%3E%0A%3CLI%3ETick%20the%20check%20box%20%3CSTRONG%3EUse%201000%20separator%20(%2C)%3C%2FSTRONG%3E.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EClick%20%3CSTRONG%3EOK%3C%2FSTRONG%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2634048%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20write%20number%20in%20Excel%20in%20the%20format%2099%2C99%2C99%2C999.99%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2634048%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Hans%2C%20My%20issue%20relates%20to%20Excel.%20In%20an%20excel%20cell%20or%20row%20or%20column%2C%20I%20would%20like%20the%20number%20to%20show%20as%26nbsp%3B%3C%2FP%3E%3CP%3E99%2C99%2C99%2C999.00%26nbsp%3B%20This%20typical%20way%20of%20writing%20numbers%20is%20followed%20in%20India.%3C%2FP%3E%3CP%3E99%2C99%2C99%2C999.00%26nbsp%3B%20would%20be%20read%20as%2099%20Crore%2C%2099%20Lakhs%2C%2099%20Thousand%2C%20999%3C%2FP%3E%3CP%3EI%20would%20like%20to%20format%20the%20number%20in%20Excel%20to%20place%20comas%20as%20I%20have%20shown%20above.%20Please%20let%20me%20know%20if%20there%20is%20a%20way%20to%20do%20that%20in%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20interest.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2634659%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20write%20number%20in%20Excel%20in%20the%20format%2099%2C99%2C99%2C999.99%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2634659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1121481%22%20target%3D%22_blank%22%3E%40KA10900gmail%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20apply%20the%20following%20Custom%20Number%20Formatting%20to%20show%20your%20number%20in%20the%20desired%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%23%23%5C%2C%23%23%5C%2C%23%23%5C%2C%23%230%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2635474%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20write%20number%20in%20Excel%20in%20the%20format%2099%2C99%2C99%2C999.99%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2635474%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20disadvantage%20of%20the%20custom%20number%20format%20%3CSTRONG%3E%23%23%5C%2C%23%23%5C%2C%23%23%5C%2C%23%230%3C%2FSTRONG%3E%20is%20that%20small%20numbers%20will%20have%20extra%20commas.%20For%20example%2C%2012345%20will%20be%20displayed%20as%20%2C%2C12%2C345%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2635502%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20write%20number%20in%20Excel%20in%20the%20format%2099%2C99%2C99%2C999.99%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2635502%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1121481%22%20target%3D%22_blank%22%3E%40KA10900gmail%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHave%20you%20tried%20the%20method%20that%20I%20showed%3F%20It%20should%20do%20%3CSTRONG%3Eexactly%3C%2FSTRONG%3E%20what%20you%20want.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How do I write number in Excel in the format 99,99,99,999.99

11 Replies

@KA10900gmail 

If you are on Windows:

  • Press Window key+R
  • Type intl.cpl and press Enter or click OK.
  • Click Additional settings...
  • Select 12,34,56,789 from the Digit grouping drop-down.
  • Click OK.

S0650.png

In Excel:

  • Select the cells that you want to format.
  • Press Ctrl+1.
  • Activate the Number tab.
  • Select Number.
  • Set Decimal places to 2.
  • Tick the check box Use 1000 separator (,).
  • Click OK.

 

@Hans Vogelaar 

Hi Hans, My issue relates to Excel. In an excel cell or row or column, I would like the number to show as 

99,99,99,999.00  This typical way of writing numbers is followed in India.

99,99,99,999.00  would be read as 99 Crore, 99 Lakhs, 99 Thousand, 999

I would like to format the number in Excel to place comas as I have shown above. Please let me know if there is a way to do that in Excel. 

 

Thanks for your interest. 

 

@KA10900gmail 

You may apply the following Custom Number Formatting to show your number in the desired format.

 

##\,##\,##\,##0

best response confirmed by KA10900gmail (New Contributor)
Solution

@Subodh_Tiwari_sktneer 

The disadvantage of the custom number format ##\,##\,##\,##0 is that small numbers will have extra commas. For example, 12345 will be displayed as ,,12,345

@KA10900gmail 

Have you tried the method that I showed? It should do exactly what you want.

@KA10900gmail 

Use this option. 

 

 
 

 

@Hans Vogelaar 

Yes, I agree. The format is good for the sample number only.

Thanks Subodh. You are right. I made the following modification to show 2 places after the decimal.
##\,##\,##\,##0.00

This question can now be closed.

You're welcome @KA10900gmail! Glad it worked as desired.

 

Btw, you didn't accept the post with the proposed solution as a Best Response.

Please take a minute to accept the correct post with the proposed solution as a Best Response.

 

Hi Subodh,
I do not see where to put proposed solution as a Best Response. Please guide me and I will be happy to do that. Thanks.

@KA10900gmail 

I haven't asked any questions in the forum so far therefore not aware of how to do this but maybe @Hans Vogelaar would guide you to do that.