Hello All,
Please help me out on this,
I have a excel report with German currency values on one column as mentioned below. I need help to create a Macro which will calculate the SUM of all of these values without changing the cell or values format.
553,12*
165,44*
435,52*
1.574,86*
564,40*
197,84*
1.259,84*
315,32*
190,84*
1.139,92*
Thanks in advance!!!
Maybe
Please Login or Register to view this content.
Hello bob
you switched the word Evlauate, lolo
Please Login or Register to view this content.
Isn't German currency supposed to be Euros?
Hmm, the Evaluate did not work for me. I think the problem is that the numbers are stored as text, and show the German number format with a decimal comma and a dot as the thousand separator. In that format, Excel does not recognise the numbers when the regional settings have different delimiters.
The following UDF can calculate the sum of the values represented by the text. First, the dot is removed from the text, then the decimal comma is replaced with a decimal point. Then the text gets converted to numbers and is summed.
There are probably slicker ways of coding this, but I'm no VBA whiz.
The code goes into a standard module. Then, in the spreadsheet use it with this syntax:Please Login or Register to view this content.
=textsum(A1:A10)
Let me know if this works for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks