View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Quietman Quietman is offline
external usenet poster
 
Posts: 109
Default Formatting Cells For Invoice Number Format

Hello I Am Trying To Complete A Spreadsheet For Work And One Collum Is For
Invoice Numbers In The Following Format 000/111-2222. Letters sometimes apear
as well as numbers so is there a way of formatting the collum so that the /
and - do not need to be typed. Hope this makes sense.

QM