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?
Try "abc/"000

Signature
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
> 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?
crapit - 05 Jan 2007 11:59 GMT
thanks
> Try "abc/"000
>
>> 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?