| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why does my formula change to a number?
I have a formula in a cell that adds the start date/time of an event to how
long the event lasts. However, when I type the formula into the cell, it automatically calculates the end date/time, and replaces the formula with the value of it. How do I keep my formula in the cell? Ex: A1: 02/23/05 12:00 pm A2: 0.5 Hrs A3: =A1 + (A2/24) When I click 'Enter', it gives A3 = 02/23/05 12:30 pm , the correct result, but it automatically replaces the formula in the cell with its value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DO NOT WANT ROW NUMBER IN FORMULA TO CHANGE | Excel Worksheet Functions | |||
| Formula to automatically change one number to another number | Excel Discussion (Misc queries) | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| want to copy formula, only change one number in formula | Excel Worksheet Functions | |||
| Formula to change number upwards. | Excel Discussion (Misc queries) | |||
Linear Mode
