Adding a digit
see response in .Excel
FormatCellsNumberCustom 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
|