Help to Format Dates in Textbox

[folky15]

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!!!!)

[AlphaFrog]

You could link it to another cell. The other cell has a formula like this to convert the date in cell A1 to a text-date.

=TEXT(Sheet2!A1,"d/m/yyyy")

[folky15]

Thank you for your help!!! That worked perfectly