graph points european

[tinybears]

Hey,

I would like to form a graph with financial data, but since the numbers
in my worksheet are in american style, points that is, it doesn't work
since it's in european style. I can't create my graphs. I've already
tried a lot, but it doesn't work at all. I used to replace points, I
changed my text into values, wrote a lot of macro's but none of them
work at all. Maybe it's something in my code, I dunno ...
It only works in Excel, but not in combination with VBA, but it's that,
what I want.

here is my code. I know it's a lot, but I'm a bit desperate. I'm
dealing with this problem for about 10 hours, and haven't done anything
since.

I would be very greatfull!

 

[HS Hartkamp]

Have you tried the VALUE function as part of your struggle ?

e.g. cell B2:
= VALUE(replace(replace(A1,",","") ,".",",")

(in words: inner replace replaces all commas with nothing, outer replace
replaces the decimal point by a comma and the value function makes sure you
convert the string to a number. Make sure the format of the cell B2 is
general or number -before- you enter the formula. Check that you get a
number by the alignment (should be right; left signals text format) when all
alignment buttons are not clicked.

Bas Hartkamp.