View Single Post
  #1   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

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!