Dear List, This is really an Excel question, but I can’t find the answer so I’ll try you all.
I am trying to create a template for exporting data from one form and importing it into a very different form. So I’ve exported the data from the first form into a comma-separated-file (csv), and opened the file in Excel. In the cell after all the data columns I am trying to build the import file data row. The date fields appear as dates in the main spreadsheet. But when I try to insert them into a formula they appear as long decimal numbers. Eg in the O2 cell I see “5/6/2009 4:34:00 PM”, but when I insert “O2” into a formula as: . . . &CHAR(34)&O2&CHAR(34)&. . . the O2 value appears as "39939.6902777778”. I’ve tried the DATE and DATEVALUE. The formula that Excel uses to create these date numbers is way too complicated to convert into a Remedy date integer. How can I get the date to appear as a date in my formulated field? Dwayne Martin James Madison University