Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula to add dates. | Excel Worksheet Functions | |||
Pre-1900 dates | Excel Discussion (Misc queries) | |||
Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
How do I get the dates on an excel chart to stay as dates instead. | Charts and Charting in Excel | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) |