On Sun, 12 Nov 2006 11:13:01 -0800, 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 -

Depending on how the data is getting into your email program, you will need to
convert the date into a text string.

For example, if your date is in Sheet1!A1 and your new document is Sheet2 then:

Sheet2!A1: =TEXT(Sheet1!a1,"mm/dd/yyyy")

If that doesn't work by itself, then select Sheet2!A1 and Edit/Copy, then
Edit/Paste Special Values


--ron