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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You could pre-format the cell as text unless you have dependent formulae that
require this input to be formatted as numeric.
 
Back
Top