Thanks Peter.
I put the spreadsheet ("IHS V2".xls) on my Office Live site:
http://suzleigh.com/MERGE.aspx
I'm running Office 2003.
BTW: This is the actual Excel data that I'm linking to the form you helped
me with last month -- which is working beautifully (except for the date).
I know that there are still some kinks in the spreadsheet (I can't get the
coding right on the drop-down validations), but am running out of time to
mess with it.
Thanks again -- Suz
"Peter Jamieson" wrote:
Over an hour spent on this stupid...
Yes, it's a frustrating problem.
Which version of Word/Excel? Was the sheet created in this version of Excel?
Is this just one spreadsheet?
Are all the items in the offending column dates, or are some numeric?
If you want, despam my e-mail (take the KillmapS out of
), send me your Excel workbook and I will try
to have a look: however, I am not around for much longer right nowand will
be out of the picture later and from tomorrow onwards
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Suzanne" wrote in message
...
Over an hour spent on this stupid...
I've changed all my Excel date formats to a specified "Date" format:
"dd-mmm-yyyy" (vice "Custom: yyyyMMMdd") (didn't help)
I've opened my Excel spreadsheet as the data source (not working)
I've opened using "Connect to new data source.odc" as the data source (not
working)
I re-opened (refreshed) the data source after changing the Excel
spreadsheet
(not working)
I've spent considerable time looking at old posts (not helping as of yet)
I'm testing dates on a plain page -- the only thing on the page are the
following mergefield codes -- which are consistently resulting as "39375"
{MERGEFIELD "STARTDATE"}
{MERGEFIELD "STARTDATE" \@ "dd-mmm-yyyy"}
What do I need to do to get my date to show up as 20-Oct-2007 (or better
yet, "20071020")?
BTW, telling me to update a service pack won't do me any good -- I'm on a
system which, for the most part, is locked down by administrators (I
assume
they have already installed all the service packs anyway)