i shall try and come back, thank you
mayank

"tjtjjtjt" wrote:

I only tried this on one number and in one simple formula, but this Custom
Format worked with that limited testing:
##\,##\,###.##

tj

"Mayank" wrote:

I am using XP with office 2000. I have enetered the regional settings for
India, which didgit groupings as ##,##,###.## But the excel does not
recognises this grouping system. How to configure to get this digit gruoping.