G
Guest
How do a format a cell reference (date format) that is a part of a text string in Excel.
Ex. ="as of "&A1 Cell A1 contains a date.
Ex. ="as of "&A1 Cell A1 contains a date.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JudithJubilee
Try Format + Cells + Custom and type the following
"as of "dd/mm/yyyy
Hope this is what you mean
Judith
"as of "dd/mm/yyyy
Hope this is what you mean
Judith
part of a text string in Excel.-----Original Message-----
How do a format a cell reference (date format) that is a
B
Bob Phillips
="As of " & TEXT(A1,"dd mmm yyyy")
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
A
Andy B
Hi
Try this:
="as of "&TEXT(A1,"dd/mm/yy") or "mm/dd/yy" for US date
Andy.
Try this:
="as of "&TEXT(A1,"dd/mm/yy") or "mm/dd/yy" for US date
Andy.
D
Dave Peterson
One more way that'll keep that cell as a date, but make it look like what you
want:
Format|Cells|number tab|custom
"As of "mm/dd/yyyy
You could even format A1 that way and maybe not use that other cell.
want:
Format|Cells|number tab|custom
"As of "mm/dd/yyyy
You could even format A1 that way and maybe not use that other cell.