Copied values are in wrong format

[RorschachDK]

Hello

My problem is that i am copying values from one sheet like: 1355,588846 and 456,23589 and storing them in a array. When i want to display the array in another sheet the values come out like 1355588846 and 45623589.
So in the first sheet excel recorgnises the comma as a decimal number and in the other sheet as a thousand seperator. How can i change this?

My code is:

Please Login or Register  to view this content.

Best regards

[Kaper]

may be this would help:

Please Login or Register  to view this content.

PS. Are you sure that values stored in sheet Front are numbers - not text just looking like numbers?

[RorschachDK]

Please Login or Register  to view this content.

Hey Kaper

Unfortunately your command didnīt work. I can see that the cells where i take the numbers to store in the array is in the format "General".

[Kaper]

1) Despite cells are formatted as general, the value still can be text (not number).
2) How is the StoreArray declared?
3) What is the format of your destination cells

4) See forum rule 12 in http://www.excelforum.com/forum-rule...rum-rules.html and edit your post.

[RorschachDK]

2) The array is declared as a string.
3) The format is number. I have tried changing them to general but same result

Best regards

[Kaper]

So probably cause of your problem is here: "array is declared as a string".
You are writing strings into cells. Why not using array of double? Or check and correct values (texts) in the array (for instance with replace function) to follow required format.

[RorschachDK]

Thanks Kaper - Changing from String til Double did the trick.

Regarding editing my earlier post - I did..now its just code, before it was the entire post

[Kaper]

OK.
Sorry, not noted that.
Probably even such part was not needed, but anyway, now it is not "quote whole posts", so I think it is OK.

So if it is Solved - would be lovely if you mark a thread as solved. Again - description of the procedure is in rules.