Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Multiply by 1440 (24*60), and make sure the cell is formatted as either
General or Number. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "herosuper" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Significant number rounding based on key cell | Excel Worksheet Functions | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) |