Display masking

[goto_guy]

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.

[Dave Peterson]

="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

[Gord Dibben]

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


Gord Dibben MS Excel MVP

On Thu, 30 Mar 2006 15:42:56 -0600, goto_guy
<[email protected]> 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.