Thread: Formatting Cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default Formatting Cell

#\'-#\"

"Cydney Nakama" wrote:

I would like to format the cell to output #'-#". If I input 30, I want it to
return 3'-0". Please help me!