Find & Replace

[anantatara]

Hi

hello i have data from excel, but when i place it in indesign the format changes.
suppose :
number : 17,200,000.00 in indesign changed to 17.200.000,00 ( take note with "." ",")

as well as date : 04/01/2022 in indesign changed to 4/1/2022
How to solve it

Thx

[Manan Joshi · Accepted solution]

Bringing in cell formats into InDesign from excel generally causes issues. You can read the following link for a workaround

https://creativepro.com/topic/excel-import-preserve-number-formats/

-Manan

[anantatara]

Terimakasih manan.
ini masalah lain setelah kemaren berhubungan dengan tanggal.

Akantetapi bisakah saya memanfaatkan GREP untuk mengganti "," menjadi "." ?

Saya harus belajar memahami GREP.

[Manan Joshi]

Try the following

Find What :- (\d+)(,)(\d+)
Replace With:- $1.$3

-Manan