number format

  • Thread starter Thread starter Jo
  • Start date Start date
J

Jo

Hi
How do I change/create a number format to show 00005
instead of 5? I want to use this with a control box
output so '00005 would not work.
Thanks very much
Jo
 
If you change the format of the cell to TEXT, then
whatever you input into the cell will be reflected.
It'll also still allow you to run any calculations that
you need to do as well.

Hope this helps.

Kirk
 
Jo,

Not sure what you mean by a control box, but if you format a number with a
custom format of 00000 it will show as you say, but will still be 5, and you
might need to format the target as FORMAT(number,"00000")
 
Back
Top