View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jollynicechap jollynicechap is offline
external usenet poster
 
Posts: 8
Default Custom Number Format

I need to make some labels in the following format:

001-1 to 216-1

I tried ###"-1" but this does not increment the 1st 3 digits but does
increment the -1. I also need to display the leading zero's

These need to be in one cell each

TIA