Are you copying/pasting? If so, when you copy/paste unless you paste special,
you are also copying formats.

If not, you could try:
=TEXT(Sheet2!A2,"mm/dd/yyyy")

Hope this helps.
--
John C


"jules" wrote:

I have one tab pulling in dates from another tab on a worksheet. But I am
unable to format the dates as every time I refresh the data, the dates (that
are pulled from the other tab) revert back to their own formatting. Some
read with a time, some as 1/1/08, some as 1-Jan-08? What is wrong?