Is there a way to get Excel to recognise a leading zero as a digit.
Ie. Enter the number 0645 and multiply the first digits, 06, by a given
number.
IE.. ( 06 * 2 ) = 12

The only way I can do it, is to, Format column *A* as 0000, then enter
0645 at *A1* and at *B1* the formula [ *=MID(A1+10000000,3,2)*2* ]

I know I could just enter the number as 645 and the formula,
*=Left(A1,1)*2*, but I have a need to enter it with a leading zero.


--
chequer

Old battler
------------------------------------------------------------------------
chequer's Profile: http://www.excelforum.com/member.php...o&userid=36908
View this thread: http://www.excelforum.com/showthread...hreadid=566482