Hi

JIm's formula should be OK. It is attempting to make the 'number' into a
proper number, by telling Excel to add 0 to it - and it usually does the
trick! Make sure you are using + and not &
It may be that there are trailing blanks in the cell, I suppose.
You could also try *1 instead of +0

Andy.

"dalipsinghbisht"
<dalipsinghbisht.24td3y_1142598600.792@excelforu m-nospam.com wrote in
message news:dalipsinghbisht.24td3y_1142598600.792@excelfo rum-nospam.com...

Hi Friends,

Thanks for your quick reply
Andy's second formula is working but zim's not coz it shows zero in
last......


Dalip


--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile:
http://www.excelforum.com/member.php...o&userid=32557
View this thread: http://www.excelforum.com/showthread...hreadid=523514