format cell

[crapit]

how to format cell that allow "zero leading" values.
i.e "abc/"general. cell value = 012, but only appear abc/12 instead of
abc/012?

 

[Bob Phillips]

Try "abc/"000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[crapit]

thanks

Try "abc/"000

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)