I've searched high and low for a solution to this, and have come up empty. Time to turn to the gurus!

I have Textbox1 on Sheet1
On Sheet2 in A1 I have a date (12/31/2013)

I have linked A1 to Textbox1 via Properties and the date INSISTS on being displayed as a serial number.

How do I get the Textbox to display the date exactly as I have it formatted in Cell A1???


(hopefully there is an easy answer to this!!!!)