How do I change the system separator (delimiter) to semi-colon?

In previous editions of Windows, this was accomplished via Control Panel-->Regional and Language Options. I can't find the equivalent in Windows 7.
Answer
Answer
You can change it in two ways:

1) Regional settings

Control Panel –> Clock, Language and Region –> Change the date, time, or number format

Click on Additional settings button.

2) Within Excel

Office Button (left hand corner) > Excel Options > Advanced > Editing Options > Uncheck 'Use system separators' > Define as per your needs
Like to answer questions which aren't answered for long time.

Excelee.com

68 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated July 23, 2020 Views 80,866 Applies to: