| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I am look for a formula to calculate a childs age in Years, mouth.
|
|
#2
|
|||
|
|||
|
First, hold down <Ctrl, and hit the key with the <~ on it a couple of
times. If that doesn't correct the problem, click in the "bad" cell containing the formula, and then: <Ctrl <Shift <~ Then hit <F2 Then hit <Enter. The first procedure changes the WS from Normal view to Formula view and then back again. The second procedure re-formats the cell to General, then re-enters the formula, meaning that the cell was formatted as Text before you entered the formula the first time. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "rita" wrote in message ... |
|
#3
|
|||
|
|||
|
Obviously, I posted to the wrong thread.
Pardon me! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... First, hold down <Ctrl, and hit the key with the <~ on it a couple of times. If that doesn't correct the problem, click in the "bad" cell containing the formula, and then: <Ctrl <Shift <~ Then hit <F2 Then hit <Enter. The first procedure changes the WS from Normal view to Formula view and then back again. The second procedure re-formats the cell to General, then re-enters the formula, meaning that the cell was formatted as Text before you entered the formula the first time. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "rita" wrote in message ... |
|
#4
|
|||
|
|||
|
http://www.cpearson.com/excel/datedif.htm
Gord Dibben Excel MVP On Wed, 16 Mar 2005 21:21:01 -0800, "rita" wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need help to get formula to calculate royalties recouped with sa | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
| Need Formula or Function to calculate Margin (reverse of Percent a | Excel Worksheet Functions | |||
| Formula displays does not calculate | Excel Discussion (Misc queries) | |||
Linear Mode
