Cant summarize nrs like 15.200,00

S

Sircantona

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If then Formula 3
summarizing data from various workbooks 4
conditional formatting, filtering then copying to another sheet 0
IF function problems 1
Pivot Table: summarizing two different ways 0
I need to cut characters off of a list of text cells... 2
Summarizing Forms 0
Cross refrence an index table and sum in one step? 7

Top