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.
|