Hi dwayne - I am using a localized version of excel, but I've tried just that. My solution was:
TEKST(O2;"dd-mm-åå") So for an english excel my guess is TEXT(O2;"dd-mm-yy") Observe that this is not applicable for VBA - that is an entierly different approach. with regards, Jonas Stumph Stevnsvig Remedy Developer BEC Intern IT jonas.stumph.stevns...@bec.dk -----Oprindelig meddelelse----- Fra: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] På vegne af Dwayne Martin Sendt: 7. maj 2009 17:09 Til: arslist@ARSLIST.ORG Emne: Preparing import file with date fields in Excel 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"