2 мая 2016 г. · Create dec_sep user defined name with formula =MID(TEXT(1/2, "@"),2,1) at workbook scope. Then use dec_sep as decimal separator in formulas.

10 мар. 2016 г. · Alternatively, you can use the NUMBERVALUE function. For example, if I have 3.000.000,00 in cell A1 I can enter =NUMBERVALUE(A1,",",".

20 янв. 2020 г. · The code below will replace commas with periods only if the cell's NumberFormat = "General". Right-click on a cell, select Format Cells.

19 июн. 2021 г. · The workaround that I found was adding SEP=, as the first line to my CSV file in a text editor.

24 дек. 2017 г. · Decimal separator and thousands separator are at system level. However, you can override them in Excel by editing File>>Options>>Advanced>>Use ...

16 мар. 2017 г. · I have an excel which there are some values with decimals. The values are strings, and since many countries are using it, some countries use "," comma for ...

20 июл. 2021 г. · I have a excel file with 119 sheets that I would like to get the data to plot multiple graphs. The problem is that the numeric values have comma as a decimal ...

28 нояб. 2020 г. · I have a column containing numbers with mixed decimal separators. example I need to use "," as separator. How do I change dot into comma?

2 мар. 2021 г. · There are 2 ways to deal with this local number formatting in Excel: Change the decimal and thousands separator Excel-wide.

11 мая 2015 г. · Using VBA in Excel 2010 I want to print the contents of a cell in a worksheet which is a decimal number to a file. I am using the ´Print #´ ...