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

10 мар. 2016 г. · I work with teams from multiple countries and sometimes I receive excel files that have another decimal separator than the one I use.

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 #´ ...

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 г. · Click Data upper Tab · Click From Text/CSV · Choose my file that I want to read in · Click Load.

18 мар. 2015 г. · You can use the cell's Text property to get at what's actually displayed in the cell, rather than the cell's true value.

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?

12 нояб. 2015 г. · You can specify the decimal point and thousands separator by clicking the Advanced button in step 3 of the text file import wizard.

17 июл. 2014 г. · If you use the Open command in Excel you can open that, modify the advanced button in the screen "Column Data Format" (Step 3 of 3) and ...

10 июл. 2012 г. · Click the advanced button and choose how to separate decimals and thousands. Change the decimal separator to a "." and remove the thousand ...