Re: saving data as csv file

[Ricki Haines]

Mimi,

If you mean you’re losing the formatting of the xls file when saving as a 
csv file, here’s the fix. If you’ve already changed the cell formats in 
xls, do it again in the csv file (date formats, etc.).  When everything 
looks the way you want it, save the csv file and DON’T OPEN it again to see 
if it’s still formatted properly.  If you do you’ll see that the format has 
been lost and you’ll need to format again.  If you have a Case ID with 
leading zeroes,  change the format of those to Custom and enter 
000000000000000 (15 0’s) or however many you have as your input length. It 
took me a while to get the hang of this, but now I have no problem 
importing into Remedy.

HTH,
Ricki Haines




On Tue, 12 Sep 2006 12:00:18 -0700, Mimi Lakew <[EMAIL PROTECTED]> wrote:

Hello,

  I am trying to convert an xls file to csv file so I can import the data 
in remedy as csv file.  Can anyone tell me how can I convert the file 
please?

  Thanks!

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org