Find & Replace

Forum|Forum|3 years ago
September 20, 2022
1 reply
496 views

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

This topic has been closed for replies.

Correct answer Manan Joshi

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

M

Manan Joshi

Correct answer

Community Expert

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

A

anantataraAuthor

Participating Frequently

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

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

Saya harus belajar memahami GREP.

M

Manan Joshi

Community Expert

Try the following

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

-Manan

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded