Thanks for the link. Unfortunately, it does not help me because the only way
to import into the email system is to have mm/dd/yyyy as the formatted data.
I have to get rid of the "serial number"
"Gord Dibben" wrote:
37622 is the serial number of the date.
That's how Excel stores dates.
See Chip Pearson's site for info on serial dates.
http://www.cpearson.com/excel/datetime.htm#SerialDates
Perhaps you can manipulate the field format in your email program?
Gord Dibben MS Excel MVP
On Sun, 12 Nov 2006 15:36:02 -0800, marketerinco
wrote:
Excel is doing some crazy conversion so that a date shows a number value not
the formated value. For example Excel has this as the date 37622
instead of it's actual result which should be 01/01/2003
When you are looking at the spreadsheet it looks right but on the backside
there is this number value that I can't get rid of.
"Niek Otten" wrote:
< I can successfuly do that but the program we use for our email is seeing the code.
????????????
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"marketerinco" wrote in message
...
| Sorry what I need is:
| 08/01/2006
| instead of 8/01/2006
|
| 8/01/2006 is how the field was originally and I needed to get the field to
| 08/01/2006. I can successfuly do that but the program we use for our email
| is seeing the code.
|
| "Niek Otten" wrote:
|
|
| "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
|
|
|