Thread: Use 100 separator inspite of 1000 separator in excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Use 100 separator inspite of 1000 separator in excel

--
Gary''s Student - gsnu200758


"Montu" wrote:

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