How to export in Semi-colon delimited format in excel?

[ridesign1]

Hi,
Does anyone know how to export a file in excel in semi-colon delimited?

I tried in csv but that is comma delimited, and it won't work.

thanks

 

[Gene]

Why not just do a "search and replace" in a word processor, replacing all the commas with semicolons?

 

[ridesign1]

thanks, just realised I can do that
is there any other way though?

 

[Gene]

Don't know... as I don't use Excel. Good luck

 

[weblord]

on win 98 i usually do, click on control panel and click on regional settings, click on Number tab and look for list separator, change from , to ; and click on apply don't need to restart, every time you export into .csv file from ms excel all delimiter will become ; instead the standard .csv i hope it helps

 

[ridesign1]

thanks for that i will give that a go

thanks

 

[weblord]

did it work for you as well? just update us whenever you can. you're welcome

 

[ridesign1]

hi,
sorry for the delay,
yes it works great. however i will need to edit the script so that it takes normal csv(comma) files.

thanks for all your help

 

[weblord]

glad to be of help. you're welcome.

 

[dongan]

on win 98 i usually do, click on control panel and click on regional settings, click on Number tab and look for list separator, change from , to ; and click on apply don't need to restart, every time you export into .csv file from ms excel all delimiter will become ; instead the standard .csv i hope it helps

wow. great tips and i checked. works fine.

 

[weblord]

wow. great tips and i checked. works fine.

thanks, glad to be of service.