Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert , comma to . dot in excel to do the following calculation?
Hi, I am using Excel 2007.
I would like to convert , comma to . dot (ie 0.184 + 0.041 + 0.241 etc) in order to calculate the sum on excel. Excel does not accept commas. Please advise! 0,184 0,041 0,241 0,245 0,184 0,020 0,051 0,020 0,041 0,082 0,085 0,041 0,041 0,041 0,051 0,041 0,041 0,143 0,020 0,020 0,265 0,272 0,122 0,041 0,020 0,041 0,041 0,01 0,061 0,041 0,082 0,143 0,051 0,061 0,020 0,020 0,020 0,122 0,034 0,340 0,061 0,136 0,153 0,082 0,102 0,061 0,020 0,041 0,034 0,041 0,082 0,041 0,020 0,143 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert comma to dot | Excel Discussion (Misc queries) | |||
Time exported w/ space/comma, Convert to Number | Excel Worksheet Functions | |||
How do I convert an excel file into a comma separated values file | Excel Discussion (Misc queries) | |||
Convert comma separated string to DropDown | Excel Programming |