Copy link to clipboard
Copied
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
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
Copy link to clipboard
Copied
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
Copy link to clipboard
Copied
Terimakasih manan.
ini masalah lain setelah kemaren berhubungan dengan tanggal.
Akantetapi bisakah saya memanfaatkan GREP untuk mengganti "," menjadi "." ?
Saya harus belajar memahami GREP.
Copy link to clipboard
Copied
Try the following
Find What :- (\d+)(,)(\d+)
Replace With:- $1.$3
-Manan