View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blustreaker Blustreaker is offline
external usenet poster
 
Posts: 2
Default automatically format cell based on content of another cell

I am trying to automatically format a cell to display its contents in either
a date or number format based on which letter is displayed in another cell in
the same row. I.E. cell 5a value is M, I need cell 5f to be in MMMYY
format.