"Gary L Brown" wrote:

Check your settings in the 'Regional Options' of your Windows 'Control
Panel'. Check that the settings are appropriate for your region which, I'm
guessing, is not the US.
HTH,
--
Gary Brown


Thanks Gary, but that's not the answer.

Formatting cells, columns and changing regional setting makes no
difference.... the string needs to be formatted before it reaches the
worksheet. Is it possible to apply a format to the textbox on the userform
so that excel knows how to interpret it?