View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Sircantona Sircantona is offline
external usenet poster
 
Posts: 2
Default 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!