Hi, All;
Curious, I tried this. Custom format [=100000]##\,##\,##0;##,##0 gave me
1028,45,678 instead of 10,28,45,678. AutoSum worked on it, though. Adding two
of them gave me 2056,91,356. Excel treats these as numbers. It is wise to
avoid provincial assumptions about other peoples' number formats, and refrain
from blanket negatives about Excel. ;)
Regards,
Ian.

"Oliver Ferns via OfficeKB.com" wrote:

In short, you can't. Why? Because '10,28,45,678'is not a number. However,
were you to start the cell entry with an apostrophe "'" then you can
achieve the effect of 10,28,45,678. Excel will not be able to perform
numerical calculations on this cell.


Hth,
Oli

--
Message posted via http://www.officekb.com