Wat formula to use to input "000" as 3 zeros in a cell?

B

Byron

Hi anyone kind enuf to help me? I am trying to get excelt to recognise an
input "000" (3 zeros) so that my other formula can pick these 3 zero up and
process them with the mid(x,x) formula etc.
Thanks
 
J

JMB

You could pre-format the cell as text unless you have dependent formulae that
require this input to be formatted as numeric.
 
Top