SummerStudent
New Member
- Joined
- Jun 16, 2002
- Messages
- 23
Hi everyone,
Quick question. I need to combine text with a date value in another cell. I've used the following formula:
="On Order ("&INDIRECT("R2")&")"
And I get "On Order (37485)"
How do I get the final text to read:
"On Order (August 17)"
Any help would be appreciated....thanks.
Dino
Quick question. I need to combine text with a date value in another cell. I've used the following formula:
="On Order ("&INDIRECT("R2")&")"
And I get "On Order (37485)"
How do I get the final text to read:
"On Order (August 17)"
Any help would be appreciated....thanks.
Dino