Format cell to force a zero

[ipbr21054]

Hi,
My staff enter a numeric value into a cell.
This value needs to start with 0 but some staff keep forgetting and just enter say 12345 as opposed to 012345

Can you advise how this is formatted so next time a value without the 0 is entered then leaving the cell etc will add it.

Thanks

 

[MARK858]

Just for info the format doesn't make any difference, it is just the underlying value.

 

[jtakw]

Hi,

If the number of digits in the cells are always supposed to be 6 (digits that is), i.e. 012345

You can also custom format the cells 000000
then zeros will always fill whatever is entered up to 6 digits.

 

[Peter_SSs]

If the number of digits in the cells are always supposed to be 6 (digits that is), i.e. 012345

You can also custom format the cells 000000
then zeros will always fill whatever is entered up to 6 digits.

Of course that will only make the value appear to start with a zero, it wouldn't make the actual value start with a zero which is what I understood the OP to want:

This value needs to start with 0

Hi,
Ive just checked this again & now its working.
Strange.

Thanks very much.

You are welcome. Glad it is working for you now.