View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NDBC NDBC is offline
external usenet poster
 
Posts: 204
Default Adding prefix to cell entries

I have some tags that are numbered from
982 00000000 to
982 00000300

I tried using the cell fomat "982 00000"@ to allow me just type in the part
that is changing (IE 0 to 300) for ease of use and less errors. My trouble is
this doesn't force the extra 0's for tag numbers below 100. Can I do this as
it is not a number because of the space.