View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jon Jon is offline
external usenet poster
 
Posts: 183
Default How to make control number in cell

Hi,
I have a cell that I want to be a control number for documents. What I want
to do is making this cell contains 3 difference data type e.g. SH-07-001
The SH is two letters, 07 is the current month and change by the beginning
of new month (automatically) and the 001 change by the new month (001+1)
Can any body help me please???