problem with MID()
One way
=TEXT(MID(A1,1,LEN(A1)-2),"00")
or
=MID(A1,1,LEN(A1)-2)
and use custom format
--
Regards,
Peo Sjoblom
(No private emails please)
"Adam Kroger @hotmail.com" <adam_kroger<nospam wrote in message
...
I am trying to use MID to extract teh first 2 numbers of a 4 digit number
that is in a cell. The problem is, the number sometimes has a "0" as the
first digit and when this happens, MID() ignores the 0, and reads the 2nd
and 3rd character. So:
Cell A1 = 0123
Cell B2 =MID(A1,1,2)
Returns 12 instead of 1
How can I fix this? I need tehm to stay numbers so I can use them in
mathmatical operations in another formula. I thought I had teh problem
solved by formatting the cell to "Number -custom 0000"
TIA
Adam
|