I need to convert all my numbers from what I think is the french way to American/English.
1 023 696 Correct 1,023,696
0,04 correct 0.04
I've found a Grep style converting all space to, that's brilliant, except that all my numbers have a space at the end so I end up with a comma at the end as well...
Does anyone know how I can delete space after a number in a table cell?
This finds any horizontal space - looks ahead for 3 digits
1 00 - won't work
1 000 replaced by 1,000
1 000 000 replace by 1,000,000
and so on
The other grep would be
Thanks! It almost works like magic! Some numbers like 156 have a space in front and end up ,156. Anyway to get around that?
The other grep works perfectly!
GREP looks for patterns - so if the pattern doesn't fit you need another pattern.
It might be possible - you'd have to give examples of live text to test fully.
Find what: \d\K\h(?=\d\d\d) Change to: ,