View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Procash Procash is offline
external usenet poster
 
Posts: 1
Default Coma Separator in Numbers

Excel has a Thousand coma seperator. I need the numerals to be displayed /
entered having a hundred coma seperator. (i.e.) Excel accepts and shows the
value "A hundred Million" as 100,000,000.00. I want this to be accepted and
the number shown as 10,00,00,000.00. I would like to know how do I change the
position of the Coma Seperator?