Cant summarize nrs like 15.200,00
 

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!

Cant summarize nrs like 15.200,00
 

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!

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!

Cant summarize nrs like 15.200,00
 

Glad it helped.
--
David Biddulph

"Sircantona" wrote in message
...
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!