gasraist.blogg.se

• EXCEL CONVERT COMMA TO DECIMAL POINT CODE

So i guess it has something to do with the fileformat?!Įdit2: I found out that when deleting newWb.close, the file is saved with a decimal comma. OldWb.Sheets(1).Range(Cells(2, 1), Cells(lRow, lCol)).CopyĮdit: interesting thing is that if I save it as. LCol = oldWb.Sheets(1).Cells(1, Columns.Count).End(xlToLeft).Column

LRow = oldWb.Sheets(1).Range("A" & Rows.Count).End(xlUp).Row If it has something to do with my macro-code, here it is: Sub CopyPrice()įor firstCell = 2 To Cells.SpecialCells(xlCellTypeLastCell).Row Where can I change that, or why does Excel change it on the first hand? I enabled the box in options to use the settings from the operating system (I am in Germany), but it doesn't help. īut I need a comma as decimal mark in the final file. The macro then saves and closes the new file, and it also changes the decimal mark from, to. The data that I copy includes prices (important note: german prices, so the decimal mark is a, instead of a. I could use the NUMX-format, but then I'll get decimals even for the integer (which stands for 90 of the values). I want to use a format like Best-format, where I exchange dot with comma. I am copying some lines with a macro into a new file, and save it as. It's important when you work with export to excel (swedish version) from WRS. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.

EXCEL CONVERT COMMA TO DECIMAL POINT CODE

NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified And, tad-aah: These look like real numbers to me. How can I replace dot in all decimal numbers to comma as a mass replacement in a column The column is already 'decimal number' type but some of the numbers come with dot from the SQL and the column doesn't recognize them as numbers and they are then 'text'. The trick is that you tell Excel here which character is a decimal, and not what it should be. Only text posts are accepted you can have images in Text posts Change the decimal to a dot, and the thousands separator to a comma.Use the appropriate flair for non-questions.Post titles must be specific to your problem.