Try

=Format(range("start_Date"),"dd-mm-yyyy")

If this post helps click Yes
---------------
Jacob Skaria


"Ronio" wrote:

I was able to use Ron DeBruin's excellent macro to take a master sheet and
break it into seperate sheets based on a value in the first column.

Now I need a macro that will save every worksheet to HTML with the 'add
interactivity' box checked.

Can somebody point me to an existing macro?

TIA,
Ron