Help with format and numbers

#1

Hi Everyone!, i have a problem when i need to set a number format to various columns in excel.
for example some values comes like:
111.2222,33
111.222,3300
111,222.222
111,222,33

and i want all like: 111222,33 or 111222.33 im a little stuck, some culturevariant gonna help? or how can use some filter to catch the different values and turn it one by one.

sorry for the bad english and all the helps is welcome thanks.

#2

Hi @Jonathan_Trimigliozz

Use regex matches and pass the input

and pattern \d

Thanks
Ashwin S

1 Like
#3

Hi @Jonathan_Trimigliozz

Check this component and it might help you to get it fixed…

2 Likes
#4

thanks for the help the problem was solved

1 Like
#5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.