Thread: Use 100 separator inspite of 1000 separator in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Montu Montu is offline
external usenet poster
  
Posts: 50
Default Use 100 separator inspite of 1000 separator in excel
Suppose A1 number is 120000.00. Now I want to separate it by 1000 & 100, i.e.
1,20,000.00. If I format the cell - Number & click on 1000 separatetor. It
show like 120,000.00. Is there any custom format to show 1,20,000.00 in excel
2003
Reply With QuoteReply With Quote