rhb1

Now I am out of my depth. Is that within .NET ? Don't think its part of standard Exel ? RHB1

If only it was that simple. That wroke within any cell within the Worksheet. I have created a text object,via the Control toolbox, which is linked to a specific cell via the LinkedCell property. Even though the cell is in a date format, it shows the cerial number within the text object. Wondered if anyone knows a way of formatting it within the LinkedCell property. Have tried Format(CellNo,"DD/MM/YY") but the property does not like it. I ams sure I could code it in the macro but though there must be an easier way. RHB

Does anybody know how to validate a Text field, selected from the Control Toolbox within Excel, so that it displays dates in dd/mm/yyy format rather than the serial number ? Thanks RHB