Try using a textbox from the drawing toolbar rather than from the control
toolbox toolbar.

--
Regards,
Tom Ogilvy

"funkymonkUK" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi
>
> I have a textbox which uses a date value in a cell from the
> spreadsheet. At the moment it shows the value of the cell as m/d/yy how
> do I get it to view dd/mm/yy?
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=414234
>