Display masking
 

I seem to remember doing this before, but of course cannot remember
how.

I'm modifying a quote spreadsheet. Current formatting doesn't permit me
to change the layout too much.

For illustration purposes, cell A1=today().
I want cell A2 to read "Quote expires " 91 days after cell A1

If I enter ="quote expires "&a1+91
cell displays "quote expires 38897"

Isn't there a way to mask the (a1+91) to display as a date?

Thanks for your help.


--
goto_guy
------------------------------------------------------------------------
goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557
View this thread: http://www.excelforum.com/showthread...hreadid=528310

Display masking
 

="quote expires " & text(a1+91,"mm/dd/yyyy")



goto_guy wrote:

I seem to remember doing this before, but of course cannot remember
how.

I'm modifying a quote spreadsheet. Current formatting doesn't permit me
to change the layout too much.

For illustration purposes, cell A1=today().
I want cell A2 to read "Quote expires " 91 days after cell A1

If I enter ="quote expires "&a1+91
cell displays "quote expires 38897"

Isn't there a way to mask the (a1+91) to display as a date?

Thanks for your help.

--
goto_guy
------------------------------------------------------------------------
goto_guy's Profile: http://www.excelforum.com/member.php...o&userid=30557
View this thread: http://www.excelforum.com/showthread...hreadid=528310

--

Dave Peterson

Display masking
 

="qoute expires " &TEXT(A1+91,"mmmm d" &"," &"yyyy")


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 15:42:56 -0600, goto_guy
wrote:


I seem to remember doing this before, but of course cannot remember
how.

I'm modifying a quote spreadsheet. Current formatting doesn't permit me
to change the layout too much.

For illustration purposes, cell A1=today().
I want cell A2 to read "Quote expires " 91 days after cell A1

If I enter ="quote expires "&a1+91
cell displays "quote expires 38897"

Isn't there a way to mask the (a1+91) to display as a date?

Thanks for your help.