What do you mean by back end formatting?

One workaround is to convert the date to text (=Text function) before the
export. Then it will stay as formatted.

--
Regards,
Fred


"marketerinco" wrote in message
...
No luck. It still will not import. It is still seeing the back end
formatting that Excel does to the field.

"Rookie 1st class" wrote:

Control Panel Regional and Language Options.
Configure short date as you want and your problem will disappear.
Been there done that
Lou


"marketerinco" wrote:

I have a problem that I have been working on for days. I need my date
fields
to read Ex: 08/01/2006 instead of 8/01/2006. I went into format field and
selected a custom format and was able to change it to the correct format.
When I save it and try to import it into an email program I get a message
that it's not formatted properly because it is seeing the backend
formatting
which has the number equivilant.

Is there any way to cut and past into a new document and only take the
final
outcome not the format? I have spent about 3 hours today on this and by
morning my client will be a little upset that this isn't done.

help!!! Thanks -