number formatting in Excel

  • Thread starter Thread starter sri
  • Start date Start date
S

sri

I need to format numbers in two different formats in a
spreadsheet
1. ###,###,##0.00 - This is not a problem, but
2. ##,##,##,##0.00 - I am unable to diplay a number in
this format.

Appreciate if someone could help me out.

Thank you.
 
I just went to
Format
Cells
Number
Custom
and typed in your second format and it worked fine.
I am using the XP version of Excel
Alan
 
Alan, Thanx ...
But I am unable to do it in Excel 2000, had tried this
earlier

Appreciate any tips for Excel 2000.

Thank you
 
Back
Top