UpTheArgyle
Board Regular
- Joined
- Jan 12, 2006
- Messages
- 179
Hi
Is it possible to have one cell copy the text of another?
I have a date in one cell formatted as "DDD" so the result is "Mon" or "Tue" etc
What i want to do is have another cell just look at the text e.g "Mon" and display it in the cell as text and not a numbered date format.
Possible?
Is it possible to have one cell copy the text of another?
I have a date in one cell formatted as "DDD" so the result is "Mon" or "Tue" etc
What i want to do is have another cell just look at the text e.g "Mon" and display it in the cell as text and not a numbered date format.
Possible?
