G Guest Mar 17, 2004 #1 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.
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.
J JudithJubilee Mar 17, 2004 #2 Try Format + Cells + Custom and type the following "as of "dd/mm/yyyy Hope this is what you mean Judith -----Original Message----- How do a format a cell reference (date format) that is a Click to expand... part of a text string in Excel.
Try Format + Cells + Custom and type the following "as of "dd/mm/yyyy Hope this is what you mean Judith -----Original Message----- How do a format a cell reference (date format) that is a Click to expand... part of a text string in Excel.
B Bob Phillips Mar 17, 2004 #3 ="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)
="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)
D Dave Peterson Mar 18, 2004 #5 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.
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.
