Thread: Adding a digit
View Single Post
  #2   Report Post  
Roger Govier
 
Posts: n/a
Default 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