Hello,
I want to write in a cell a coordinate in decimal format like 12.345678. I can't configure what formatting needs to be done in the cell so it can be used in hyperlink. If I put a . it makes it a number like 12.345.678. If I make it a comma , it isn't recognized by the hyperlink formula as coordinate. The only way that works is by not using the default system seperators and change them to , for thousands and . for decimal. But this change effects to all the workbooks that you open in excel, therefore some other formulas don't work. Is there a way to make the change only for specific workbook? Any suggestions on my problem will be appreciated. Thank you.