I believe it's the default format for continental Europe, so maybe they do
business with Europe

One way (in windows xp) is to do windowsstartcontrol panel regional
settings, click customize and change list separator from comma to semicolon.
That way when you save as *.CSV it will replace the commas with semicolon.
Of course you need to remember to change it back when you are done. Don't
know if that's easier than to open it in a text program and replace them.
OTOH there are quite a lot of code out there for exporting excel files using
other delimiters. McGimpsey's website is down at the moment

http://www.mcgimpsey.com/excel/textfiles.html


http://www.cpearson.com/excel/ImpText.aspx


--
Regards,

Peo Sjoblom



"Bob I" wrote in message
...
Wow, makes you wonder doesn't it!

Whit wrote:

??? I have asked the same question. The quote from a programmer was: "Our
largest client wants it this way." Go figure.

"Bob I" wrote:


Why doesn't the software accept standard CSV files?

Whit wrote:


The software that I use requires a specific format in order to upload
data. Is there a way to save a file with a semi colon as a deliminator.
I can save as a comma file and then import into word pad, then repalce
with a semi colon. There has to be a better way.

Thanks