Hi Rajeev,

formatting does not change the value of a number in excel. Just check if
excel is treating 2,32,000 as text, which you can simple come to know
visually if it right- or left-aligned. If it is left aligned then it is
text. Otherwise just check the cell with the function:
=ISNUMBER(A1)
It should return true for numbers and false for text.

BTW, what formula or operation are you trying to do on these numbers.

Mangesh



"rajeev" wrote in message
oups.com...
It is neither of the two but is two lacs thirty two thousand i.e.one
digit less then million.1million=10 Lacs.We in india generally uses
lacs figures instead of millions.If this fig. is 2320000 then it can be
called as two point three million & thirty two thousand.
I hope now u can understand the relation between millions & lacs & can
be able to solve my problem.

Thanks
Rajeev