Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
Hi folks, I have posted this problem in the Word group without
success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
Excel maintains dates as numbers. Excel's date range is from Jan. 1, 1900,
day 1, to Dec. 31 9999, day 2,958,465. Word does not maintain dates as numbers. Word maintains dates as text. Excel simply formats the numbers to display as a human understandable date. Tyro "Boppy" wrote in message ... Hi folks, I have posted this problem in the Word group without success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
On Mar 16, 1:34 pm, "Tyro" wrote:
Excel maintains dates as numbers. Excel's date range is from Jan. 1, 1900, day 1, to Dec. 31 9999, day 2,958,465. Word does not maintain dates as numbers. Word maintains dates as text. Excel simply formats the numbers to display as a human understandable date. Tyro "Boppy" wrote in message ... Hi folks, I have posted this problem in the Word group without success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo Yes, I realise that. Is there any way to filter dates though? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
Your best bet would probably be to filter in Excel, rather than in Word.
Another option is to use a helper column with =TEXT(A2,"m/dd/yyyy") -- David Biddulph "Boppy" wrote in message ... Yes, I realise that. Is there any way to filter dates though? On Mar 16, 1:34 pm, "Tyro" wrote: Excel maintains dates as numbers. Excel's date range is from Jan. 1, 1900, day 1, to Dec. 31 9999, day 2,958,465. Word does not maintain dates as numbers. Word maintains dates as text. Excel simply formats the numbers to display as a human understandable date. Tyro "Boppy" wrote in message ... Hi folks, I have posted this problem in the Word group without success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
On Mar 16, 6:56 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: Your best bet would probably be to filter in Excel, rather than in Word. Another option is to use a helper column with =TEXT(A2,"m/dd/yyyy") -- David Biddulph "Boppy" wrote in message ... Yes, I realise that. Is there any way to filter dates though? On Mar 16, 1:34 pm, "Tyro" wrote: Excel maintains dates as numbers. Excel's date range is from Jan. 1, 1900, day 1, to Dec. 31 9999, day 2,958,465. Word does not maintain dates as numbers. Word maintains dates as text. Excel simply formats the numbers to display as a human understandable date. Tyro "Boppy" wrote in message ... Hi folks, I have posted this problem in the Word group without success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo Thanks. I have been filtering in Excel, creating a new worksheet with that data, then mail merging with that sheet. It is a bit annoying that it's necessary to find workarounds when dealing with products from the same developer though. Surely I am not the first person to have this requirement ... B |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
A date filter should work in Word, for Excel data. What solutions were
suggested in the other groups, that didn't work? Were you able to use the date filter in a previous version of Word? I can't see what your regional settings are, but from the Excel screen shot it looks like m/d/yyyy is your short date. You could try mm/dd/yyyy instead, to see if that helps. You might want to blur your clients' personal data in your screen shot though. They might not appreciate having it posted publicly. Boppy wrote: Hi folks, I have posted this problem in the Word group without success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
On Mar 17, 4:50 am, Debra Dalgleish wrote:
A date filter should work in Word, for Excel data. What solutions were suggested in the other groups, that didn't work? Were you able to use the date filter in a previous version of Word? I can't see what your regional settings are, but from the Excel screen shot it looks like m/d/yyyy is your short date. You could try mm/dd/yyyy instead, to see if that helps. You might want to blur your clients' personal data in your screen shot though. They might not appreciate having it posted publicly. Boppy wrote: Hi folks, I have posted this problem in the Word group without success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html Hi Debra, thanks for replying. There were no suggestions made in the other groups at all, other than a work around similar to what I was already doing. When you say "You could try mm/dd/yyyy instead, to see if that helps." do you mean when filtering in word, or do you mean I should try setting my regional settings to this? B |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
I meant that you could change the short date in the regional settings to
mm/dd/yyyy, and see if that helps with the filter in Word. Boppy wrote: On Mar 17, 4:50 am, Debra Dalgleish wrote: A date filter should work in Word, for Excel data. What solutions were suggested in the other groups, that didn't work? Were you able to use the date filter in a previous version of Word? I can't see what your regional settings are, but from the Excel screen shot it looks like m/d/yyyy is your short date. You could try mm/dd/yyyy instead, to see if that helps. You might want to blur your clients' personal data in your screen shot though. They might not appreciate having it posted publicly. Boppy wrote: Hi folks, I have posted this problem in the Word group without success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html Hi Debra, thanks for replying. There were no suggestions made in the other groups at all, other than a work around similar to what I was already doing. When you say "You could try mm/dd/yyyy instead, to see if that helps." do you mean when filtering in word, or do you mean I should try setting my regional settings to this? B -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel dates not filtering in Word: Office 07
On Mar 18, 3:00 pm, Debra Dalgleish wrote:
I meant that you could change the short date in the regional settings to mm/dd/yyyy, and see if that helps with the filter in Word. Boppy wrote: On Mar 17, 4:50 am, Debra Dalgleish wrote: A date filter should work in Word, for Excel data. What solutions were suggested in the other groups, that didn't work? Were you able to use the date filter in a previous version of Word? I can't see what your regional settings are, but from the Excel screen shot it looks like m/d/yyyy is your short date. You could try mm/dd/yyyy instead, to see if that helps. You might want to blur your clients' personal data in your screen shot though. They might not appreciate having it posted publicly. Boppy wrote: Hi folks, I have posted this problem in the Word group without success, and also in the Mr Excel bulletin board, also without finding a solution. I wonder if anyone here can help: I do regular mail merges in Word using data created in Excel. I am almost always wanting to filter by the date the record was entered into Excel, and which was recorded by typing ctrl ; to insert the current date. The problem is, when I am filtering the data in Word, and type in the date I want the records from, I get this error message: http://i30.tinypic.com/2uz40h4.jpg Word happily filters dates that I have typed into a table in Word then used as a data source. What do I need to do to have Word recognise my Excel dates? In case this is relevant, my regional settings a http://i193.photobucket.com/albums/z...screenshot.jpg Thanks in advance for advice, Jo -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html Hi Debra, thanks for replying. There were no suggestions made in the other groups at all, other than a work around similar to what I was already doing. When you say "You could try mm/dd/yyyy instead, to see if that helps." do you mean when filtering in word, or do you mean I should try setting my regional settings to this? B -- Debra Dalgleish Contextureshttp://www.contextures.com/tiptech.html In New Zealand we use dd/mm/yy so there would be no point trying mm/dd/ yy because it would totally confuse things. Do you think it's worth trying dd/mm/yy? B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In office 2003 how can FIXEDSYS font avail in EXCEL & not in WORD | Excel Discussion (Misc queries) | |||
Excel auto filtering to find a range of dates in a list | Excel Discussion (Misc queries) | |||
Installed Word XP only, then applied Office SP3, then Excel - need 2 re-update? | Excel Discussion (Misc queries) | |||
Is anything needed if I only load Word & Excel from Office XP Sta. | Excel Discussion (Misc queries) | |||
Filtering data in Excel for mailmerge to Word | Excel Discussion (Misc queries) |