View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
marketerinco marketerinco is offline
external usenet poster
 
Posts: 12
Default Dates won't stay formated

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 -