HI Gord,

Tks for your reply.

But i dont get the display like i wanted 1,23,45,678.00 either i can make
that as 12,345,678.00 or 12,34,56,78.00 (ie either group it in 2's or 3's)

Check back and revert

Thanks

"Gord Dibben" wrote:

venky

If you want this to be the default for all Apps. you could change to that
configuration in Windows Control PanelRegional and Language OptionsRegional
OptionsCustomizeDigits Grouping.

Gord Dibben Excel MVP

On Fri, 26 Nov 2004 01:01:06 -0800, "venky"
wrote:

How do i go about formating a number to be displayed as
12,34,56,789.00 INSTEAD OF THE 123,456,789.00