Question for the Excel Experts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Digital2k - 01 Jul 2006 04:21 GMT

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

Reply to this Message

Biff - 01 Jul 2006 04:43 GMT

Hi!

Change the formula in L2 to:

=TEXT(NOW(),"mmmm")

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

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

>I have a cell (L2) with this formula: =NOW(). and this format: "mmmm" to
>show the current month.
[quoted text clipped - 9 lines]
>
> Thanks, Digital2k

Reply to this Message

Digital2k - 01 Jul 2006 05:07 GMT

Thank You very much!!!

I love this Group!
Digital2k

> Hi!
>
[quoted text clipped - 28 lines]
>>
>> Thanks, Digital2k

Reply to this Message

Biff - 01 Jul 2006 05:30 GMT

You're welcome!

Biff

> Thank You very much!!!
>
[quoted text clipped - 33 lines]
>>>
>>> Thanks, Digital2k

Reply to this Message

Dana DeLouis - 09 Jul 2006 16:54 GMT

Hi. You've got an excellent solution. Just to mention another general
idea:

L2 = Now()

=IF(MONTH(L2)=7,"It's July",T10)

Signature

HTH. :>)
Dana DeLouis
Windows XP, Office 2003

> You're welcome!
>
[quoted text clipped - 37 lines]
>>>>
>>>> Thanks, Digital2k

Reply to this Message

Rate this thread: