Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summarize | New Users to Excel | |||
PLEASE HELP ! SORT & SUMMARIZE ? | New Users to Excel | |||
Summarize Data | Excel Discussion (Misc queries) | |||
Summarize data | New Users to Excel | |||
Summarize Data Set | Excel Worksheet Functions |