Try not to become a person of success, but a person of value. - Albert
Einstein
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares
Sent: 29 June 2011 21:20
To: arslist@ARSLIST.ORG
Subject: Re: Excel frustration with AIE and Data Imports
] *On Behalf Of *Ron Tavares
*Sent:* 22 June 2011 15:31
*To:* arslist@ARSLIST.ORG
*Subject:* Excel frustration with AIE and Data Imports
** **
**
Good Morning Listers,
You how when you open a .csv file in Excel, Microsoft will do it's magic
and start changing the format
Good Morning Listers,
You how when you open a .csv file in Excel, Microsoft will do it's magic and
start changing the format of certain values? As an example, it will drop
the leading zeros form a value because it assumes it is numeric, (like a
serial number). So you have to fix the data,
I've used Access for things like that
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares
Sent: Wednesday, June 22, 2011 8:31 AM
To: arslist@ARSLIST.ORG
Subject: Excel frustration with AIE and Data Imports
Subject: Re: Excel frustration with AIE and Data Imports
I've used Access for things like that
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares
Sent: Wednesday, June 22, 2011 8:31 AM
To: arslist@ARSLIST.ORG
Subject
need to do some mass data cleaning.
Cheers
Joe
From: Ron Tavares
Sent: Wednesday, June 22, 2011 9:30 AM
Newsgroups: public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Excel frustration with AIE and Data Imports
**
Good Morning Listers,
You how when you open a .csv file in Excel
(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares
Sent: 22 June 2011 15:31
To: arslist@ARSLIST.ORG
Subject: Excel frustration with AIE and Data Imports
**
Good Morning Listers,
You how when you open a .csv file in Excel, Microsoft will do it's magic and
start changing the format
7 matches
Mail list logo