View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
shaqil shaqil is offline
external usenet poster
 
Posts: 30
Default Use 100 separator inspite of 1000 separator in excel

On Nov 23, 5:53 pm, Gary''s Student
wrote:
May you also have a nice day.
--
Gary''s Student - gsnu200758

"Montu" wrote:
Many Many Thanks to you - Gray. Hoping get more support in future. Have nice
day.


"Gary''s Student" wrote:


Format Cells... Number Custom:


0\,00\,000.00
--
Gary''s Student - gsnu200758


Sorry, but when i write 100 it shows 0,00,100.00 that looks odd. when
a figure should be less that 100,000.00 then it should look as usual.

Help required.