Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formats
I am using Excel XP. I have imported a chart from a word processing program,
not Word, into Excel. Everything works find , except for some of the date entries. I have two columns of dates, one for birth and one for death. In each column I several entries that will not reform. They show to be either 'general' or 'custom'. I have made several attempts to reformat them to 'date' but they will change Any Ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formats
Try the TRIM formula on them...
If it does not work then paste a few examples here... "david d" wrote: I am using Excel XP. I have imported a chart from a word processing program, not Word, into Excel. Everything works find , except for some of the date entries. I have two columns of dates, one for birth and one for death. In each column I several entries that will not reform. They show to be either 'general' or 'custom'. I have made several attempts to reformat them to 'date' but they will change Any Ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formats
On Sat, 13 Sep 2008 21:27:01 -0700, david d
wrote: I am using Excel XP. I have imported a chart from a word processing program, not Word, into Excel. Everything works find , except for some of the date entries. I have two columns of dates, one for birth and one for death. In each column I several entries that will not reform. They show to be either 'general' or 'custom'. I have made several attempts to reformat them to 'date' but they will change Any Ideas? They are probably there as text, and possibly with non-printing characters or <space's included. Try the Data/Text-to-columns wizard, selecting only the one column, and the appropriate date format for the source data. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Date formats | Excel Discussion (Misc queries) | |||
Date formats | Excel Discussion (Misc queries) | |||
Date Formats | Excel Discussion (Misc queries) | |||
Date formats | New Users to Excel | |||
Date formats | Excel Discussion (Misc queries) |