Hi Rajeev,

Just check some of the following things. See if there are any leading or
trailing blanks (spaces) with the number. You could also use trim(A1) to
remove the spaces at either ends of the number.
Also try to edit the number i.e. select the cell. Press F2 and Enter.
Let me know.

Mangesh



"rajeev" wrote in message
oups.com...
Hi Mangesh,
I have checked it by using ISNUMBER(CELL NO.) & it says FALSE.
Actually i am impoting data from Tally7.2 Accounting Package & making
some mathematical Calculation such as addition,subtraction on it.I
tried by using format cell & then changing text to number but no
result.

Thanks
Rajeev