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
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
.
Thanks again,
Dwayne
Original message
Date: Thu, 7 May 2009 17:17:01 +0200
From: Jonas Stumph Stevnsvig jonas.stumph.stevns...@bec.dk
Subject: SV: Preparing import file with date fields in Excel
To: arslist@ARSLIST.ORG
Hi dwayne - I am using a localized version of excel, but I've
the second has the AM or PM indicator
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arsl...@arslist.org] On Behalf Of Dwayne Martin
Sent: Thursday, May 07, 2009 1:00 PM
To: arslist@ARSLIST.ORG
Subject: Re: SV: Preparing import file with date fields in Excel
Subject: Re: SV: Preparing import file with date fields in Excel
To: arslist@ARSLIST.ORG
The TEXT function will format an Excel date into whatever format you specify.
For normal US format it would be
. . . CHAR(34)TEXT(O2,MM/DD/ HH:MM:SS)CHAR(34). . .
Or
. . . CHAR(34)TEXT(O2
5 matches
Mail list logo