=mid is not working because I have a decimal point between the numbers.


here's a better example:

Cell AO11 = 13.00
I want:
AJ11 = 1
AK11 = 3
AM11 = 0
AN11 = 0

My problem is to 0 is coming up as a blank cell instead of showing th
zero. Is there any way to show the zero

--
hyyft
-----------------------------------------------------------------------
hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318
View this thread: http://www.excelforum.com/showthread.php?threadid=26547