The formula assumes that N001 is in cell A1. If it is in a different cell,
change both references from A1 to that cell.

"John" wrote in message
...
Hi
I had copy and paste this ="N"&REPT("0",6-LEN(A1))&RIGHT(A1,LEN(A1)-1) at
N001, it change to a 0 only. can you tell how to use this formula.


"John" wrote:

anyone know how to fill in 0 between N and the #.(Formula or Macro)
N001-----------N00001
N002-----------N00002
N003-----------N00003
N004-----------N00004
N005-----------N00005
N006-----------N00006
N007-----------N00007
N008-----------N00008
N009-----------N00009
N0010----------N00010
N0011----------N00011
N0012----------N00012
N00125---------N00125
N00126---------N00126