Thread: comma seperater
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sonykadanthodan sonykadanthodan is offline
external usenet poster
  
Posts: 1
Default comma seperater
In excel worksheet comma seperator is based on 1000s . How can i change this
to 100 sperator eg: Nos One Lakh is displaying as 100,000.00 but one lakh
has to be displayed as 1,00,000.
Reply With QuoteReply With Quote