• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

Find & Replace

Community Beginner ,
Sep 19, 2022 Sep 19, 2022

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

 

 

 

TOPICS
How to , Import and export , Scripting , Type

Views

74

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Sep 19, 2022 Sep 19, 2022

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

Likes

Translate

Translate
Community Expert ,
Sep 19, 2022 Sep 19, 2022

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Sep 19, 2022 Sep 19, 2022

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.

 

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Sep 20, 2022 Sep 20, 2022

Copy link to clipboard

Copied

LATEST

Try the following

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

-Manan

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines