Re: saving to csv file from excel 2007

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I did that and the 2007 file has several commas after the information where
the 2003 file doesn't - that is the difference but I dont know how to correct
it in 2007
--
jo


"Bernard Liengme" wrote:

Open the CSV file with Notepad to see what got saved
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"pourlance" <pourlance@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC3F53B1-19D1-48E5-8FD4-F89BC15DE584@xxxxxxxxxxxxxxxx
When I save it as a csv file it doesn't hold the format it should for me
to
transfer it - it shrinks the columns, changes the date column to #### due
to
resizing it etc. I can't figure out what is different from 2003 version
that
worked fine - does this make sense?
--
jo


"Gordon" wrote:

"pourlance" <pourlance@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:11D7C094-BD37-4CBD-8E8B-6C3BB3736581@xxxxxxxxxxxxxxxx
I need to save file to csv format to transfer to website...2003 always
worked
fine - 2007 doesn't - help??


What do you mean "2007 doesn't"? Doesn't what?





.

Relevant Pages

  • Re: Want to replace SPACE delimited data file with commas
    ... The fields for 052 records are separated by spaces not tabs ... if I took out the commas I still would know when they start and end. ... code for tab I think) as I am using the PL/SQL file I/O API ... I know awk can get each file but I honestly dont know the possible ...
    (comp.unix.shell)
  • search replace retain and compare strings?
    ... the remaining string to another file. ... i dont have commas in few lines....so i am unable to split with ...
    (comp.lang.perl.misc)