Cant summarize nrs like 15.200,00
Well, that saved like 200 years of work!
Thanks!
"David Biddulph" wrote:
Data/ Text to columns/ Skip the later columns.
--
David Biddulph
"Sircantona" wrote in message
...
Hi,
I have copied numbers from our sales system into Excel. Only problem is
that
the numbers look like this:
15.200,00 (fifteen thousand two hundred).
With this format I can not summarize the columns. How do I change that?
Have
tried everything in "Format cells" I think. Is there some other way?
I do not want to retype every single nr..... =)
Appreciate your help!
|