View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yvonne Yvonne is offline
external usenet poster
 
Posts: 26
Default Custom formatting

I have a very large spreadsheet in which I need to change all dates that
appear this way: 1994 - 1995, to this: (1994 - 1995).

Is there any way I can create a custom format for the latter? Otherwise I
have to go through each cell one by one and change each one individually.

I hope someone can help...