Hi all,
I`ve got a database, in which few columns are filled by the numbers in general, accounting or custom format, but for all of them `comma style` has been applied. So they look like this:
32.200,00
119.850,00
38.608,00
11.970,00
11.970,00
thousand separator and two numbers of digits. I need to have these numbers that look exactly like this, but with a text format (I`m exporting the data to Word file, that`s why). Is it possible to do that?
So the goal is to obtain numbers that looks exactly like those above, but in text format (so no comma style is possible to be applied).
And I need to do that by using macro.
My colleague did it by pasting these columns to Notepad and then pasting it again to Excel, but I think it is not necessary
Thanks in advance for your help!
Karol
Bookmarks