View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
herosuper herosuper is offline
external usenet poster
 
Posts: 1
Default copying info from one cell to another, changing the format, but leaving the number


I would like to transfer a number from one cell to another... problem is
that after I do calculations in one format, I need the number to perform
another calculation in another format... for example, I calculate time
to get my total time (in minutes), lets say the number is 231 minutes
in the [mm] format. I now need the 231 to be transfered to another
cell but I need it in a general number format. So how do I change the
format and keep the same number? Any suggestions or ideas?




--
herosuper