see response in .Excel

Format>Cells>Number>Custom> 0000000000
Regards

Roger Govier


cj21 wrote:
> I have a long list of product codes e.g. 230956743, 485048675. But i
> want to put a zero in front of each one e.g. 0230956743,
> 0485048675. Is there a quick way of doing this.
>
> Obviously the column will have to be formatted as text because
> otherwise the zero would dissapear.
>
> Chris
>
>