Posted to microsoft.public.excel.programming
|
|
"As of" & "July 31, 2005"
sorry.. another way is to custom format the cell. you could do "As of "mmmm
d, yyyy
"Kasey Kern" wrote:
Try this formula in A3:
="As of "&A1
"Tim Russell" wrote:
Sheet 1
A1 = 7/31/05 (formated as date) = July 31, 2005
Sheet 2
I want A3 to read "As of July 31, 2005". But I want the date to be
pulled from sheet 1, cell A1.
So if I change sheet 1, A1 to August 31, 2005, then Sheet 2, A3 changes
to read "As of August 31, 2005".
How is this done?
Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
|