Skip to main content
Inspiring
March 29, 2023
Question

thousands separator

  • March 29, 2023
  • 3 replies
  • 882 views

I have numbers entered like this: 10000,25 - 24587,16 and I would like them to become like this: 10.000,25 - 24.587,16, i.e. that there was a point between the thousands while the decimal point should remain. Is there any way... a grep style for example or something similar to fix?

This topic has been closed for replies.

3 replies

Community Expert
April 1, 2023

"Is there any way... a grep style for example or something similar to fix?"

 

Hi @stefanofe ,

no way to do this with a formatting option like a GREP Style defined in a paragraph style.

With a GREP Style you would be able to change formatting, but you are not able to add (or remove) characters.

 

However, with GREP Find/Change this is possible.

See into the link Manan Joshi provided.

 

The first solution is working with InDesign 2021, 2022 and 2023:

Find:

 

(?<=\d)(?=(\d\d\d)+(?!\d))

 

Change:

 

.

 

 

The second one as well when written like below:

Find:

 

(\d)(?=(\d\d\d)+(?!\d))

 

Change:

 

$1.

 

For older versions of InDesign below 2021 use the second one.

The first one is not working.

 

Regards,
Uwe Laubender
( Adobe Community Expert )

Community Expert
April 1, 2023
Steve Werner
Community Expert
Community Expert
March 29, 2023

Looks like it could be done with GREP. But I'll let the GREP experts answer.