View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fsudiane fsudiane is offline
external usenet poster
 
Posts: 1
Default convert column with inches to 2 columns "feet" and "inches"

I have a spreadsheet that has a column with total inches, but what I really
need is 2 columns that shows how many total feet there are in one column and
how many left over inches there are in the 2nd column. What formula can I use?