Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have one column with increasing standard time (hr:min:sec). I put a
formula in the first cell of the first row of a second column to convert the same cell of the first column to a value of decimel based upon minutes. The result is correct in the first cell of the first line (row) where the the formula was placed in the second column, but when I copy the formula throughout the rows of the second column, the results shown are always the answer for the first line - even though when I klick on the cell the formula in the lower rows/cells shows it referring to the correct later time of the lower row & cell. Why??? is my Excel corrupted?? The value shown by the cell does not fit formula of the cell! |
#2
![]() |
|||
|
|||
![]()
Most probable:
Tools/Options/Calculation, click the Automatic radio button. In article , "wu-fu" wrote: Why??? is my Excel corrupted?? The value shown by the cell does not fit formula of the cell! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula problem on network | Excel Discussion (Misc queries) | |||
problem with Array Formula | Excel Worksheet Functions | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
Need a formula for this problem | Excel Worksheet Functions |