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 -