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