changing settings: comma into point

[dennis_bodewits]

hi there! currently, my excel is set to have a comma as a delimiter. a
is want to copy-paste point-delimited data into excel, i have t
change the excel-settings i guess? does anybody know where i can fin
this option?


denni

 

[Stephen Bullen]

Hi Dennis,

hi there! currently, my excel is set to have a comma as a delimiter. as
is want to copy-paste point-delimited data into excel, i have to
change the excel-settings i guess? does anybody know where i can find
this option?

In Excel XP and above, Tools > Options > International

Otherwise, you'll have to change your Windows regional settings in
Control Panel.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

 

[Andy B]

dennis

You could copy and paste the data as it is and use Data/Text to columns.

Andy.