Changing decimal separator only for one document

Question

_{Thursday, September 28, 2017 9:48 AM}

Hello Excel Pro's

i have a question about the decimal separator. It is possible that i change the decimal separator only for one document? Not for the whole System (Region Settings) nor Excel (Options - Advanced Settings - Use OS Separators).

I use a data import (new query - other sources - web) with other decimal settings, as we have in our country.

I hope you could help me.

Thanks a lot

Kind Regards

Markus

All replies (1)

_{Friday, September 29, 2017 9:41 AM}

Hi Markus,

>> It is possible that i change the decimal separator only for one document?

There is no workbook specific equivalent of region/language settings.

However, if your data is either date or currency, then it is possible to specify the format of ranges within the worksheets to format using regional specific formats. Just select the range, and press Ctrl +1, to open the Format Cells dialog.

Regards,

Ethan Hua

Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact [email protected].