I am look for a formula to calculate a childs age in Years, mouth.

R

Ragdyer

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
How do I find age in years from anniversary date (Age funtion)? 1
Calculating a person's age 2
how do I stop re-calculated fields in excel from going "black" 1
Age Calculation 4
Help: Formula for calculating Baseball League Age? 4
Formula in Excel does not work until after I double-click inside c 8
When I enter a formula it shows the formula not the result 1

Top