The format of decimal numbers changes in excel

[DirkRuijne (D A Ruijne)]

I retrieve decimal numbers from an Oracle database. The decimal is a comma. I put the numbers in an Excel spreadsheet. The cells in which the decimal numbers appear have the format: text. The numbers are displayed correctly with a comma as a decimal. Then I read the numbers into a data table with read range. The numbers appear to be included in the data table with a point as a decimal. If I then write something in a cell with write cell, the comma of all decimal numbers in the spreadsheet is changed to a point. I want the decimal to remain a comma. How can I achieve this?

[Anil_G (Anil Gorthi)]

@DirkRuijne

that depends on the current locale you are in

thats the number format…the display value can be different from backend value

if comma is already present then while reading try to use read range with display values as forward instead of raw value

cheers

[DirkRuijne (D A Ruijne)]

I’ll try read range wityhe display values.

[prashant1603765 (Prashant Kumar)]

Hi @DirkRuijne
I’m also getting same issue then i use this and issue resolved.
Pls try

Found helpful, Mark as a solution Tick.
Thanks

[DirkRuijne (D A Ruijne)]

Thanks both. I’ll try. Takes a moment. will give you feedback soon.

[DirkRuijne (D A Ruijne)]

I read the excel file with system-file-workbook-Read Range with the property PreserveFormat activated. This did not work. So I tried Office 365 - Classic - Read Range with the property display value activated as you recommended. Neither worked. But a colleague found the solution:
I retrieve the data from an Oracle database. This is done with the Oracle SQL-client which produces the data in a CSV-file. Thsi csv-file is transferred tot a datatable with the adtivity: Generate Data Table to be able to write the data to an excel file. In thsi activity the property: AutoDetectTypes was activated. I disabled it. This resolved the problem: also the decimal data are now in text format.

Thank you very much for your prompt reaction!