Question for the Excel Experts

D

Digital2k

I have a cell (L2) with this formula: =NOW(). and this format: "mmmm" to
show the current month.

I have another cell (H3) with this formula: =IF(L2="January",T10,).

The problem is cell (H3) is reading the formula and not the text.

How can I have the current month show in (L2) but have (H3) read the Text
and not the formula?

Please Help

Thanks, Digital2k
 
B

Biff

Hi!

Change the formula in L2 to:

=TEXT(NOW(),"mmmm")
The problem is cell (H3) is reading the formula and not the text.
Click to expand...

The problem is/was that NOW( ) returns a NUMERIC value but you have
formatted it to look like the TEXT string JUNE.

Try this:

Enter =NOW() in an empty cell
Now, format that cell as GENERAL.
The value you now see is the cells true underlying value.

Biff
 
Top