Display masking

G

goto_guy

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

I'm modifying a quote spreadsheet. Current formatting doesn't permit m
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
 
D

Dave Peterson

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



goto_guy said:
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.
Click to expand...
 
Top