"marketerinco" wrote in message
...
|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
| Ex: 08/01/2006 instead of 8/01/2006
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 -

<Ex: 08/01/2006 instead of 8/01/2006

Do you really mean you need "Ex: " in front of the original format?

<was able to change it to the correct format

What format?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel