I have a workbook with multiple linked worksheets, where various cells are
linked to other worksheets.

One work sheet has a date of format xx-January-xxxx which transfers to other
worksheets within the workbook, but I wish to convert the date to upper case.
Using the upper function on the second worksheet, the date transfers OK, but
as numeric format.
I have tried setting cell formats, but the date always transfers as a
numeric value.

Any suggestions?

Thankyou