View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpal dpal is offline
external usenet poster
 
Posts: 33
Default Adding New Cell Formats

I have added a few custom Cell formats to the list given with Excel. #,##0 etc.
I have adde 0) and (0) etc.
Is there a formula I can write to enter feet and inches so I don't have to
use ' & " everytime I enter.
I have to type 1'-2". Is there a way I can format the cell so I just have to
enter 1-2 or something short like that?

thanks
dpal