View Single Post
Old 11-04-2007, 05:00 PM   #8 (permalink)
Choto Cheeta
Rebooting
 
Choto Cheeta's Avatar
 
Join Date: Aug 2004
Location: 220.225.82.33
Posts: 6,266
Default Re: How to change digit grouping in Office 2003 ?

OK... Found a makeshift solution...

Its a solution by our co-MPV Dr. U.B. Pavanaja, select the cell or cells in excel, now go to Format Cell, and then option Custom under Number Catagory !!

Here, enter this custom formating vallue... !!

##\,##\,##\,##0.00



Now it should re-format the digit in this style, 12,34,56,789.00 but its a make shift solution as if you have digit bigger than that, you will have to do increase the ##\, according to your needs.. !!

How ever its not any offcial reply from MS

Post back if any more problem !!
__________________
rebooting
ChotoCheeta.com
Choto Cheeta is offline