View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CMEknit CMEknit is offline
external usenet poster
 
Posts: 3
Default Formatting cells for letters and numbers

I would like to be able to enter 'F0708' in a cell and have it display as
'F-07-08' but can't figure out how to accomplish that.

Can this be done and, if so, how? I'm totally stumped! Thanks.