Elitist Jerks

Elitist Jerks (http://elitistjerks.com/forums.php)
-   The Banhammer (http://elitistjerks.com/f34/)
-   -   Warning for Boozie: 6. Do not post unless you have something new and worthwhile to say. (http://elitistjerks.com/f34/t73202-warning_boozie_6_do_not_post_unless_you_have_something_new_worthwhile_say/)

Aldriana 09/05/09 6:24 PM

Warning for Boozie: 6. Do not post unless you have something new and worthwhile to say.
 
Post: Warrior DPS Calculation Spreadsheet
User: Boozie
Infraction: 6. Do not post unless you have something new and worthwhile to say.
Points: 0

Administrative Note:

Message to User:
Quote:

Thanks are better sent via PM.
Original Post:
Quote:

Quote:

Originally Posted by Rdza (Post 1376313)
Problems with SEP macro is caused by regional differences. In US dot "." is used to separate numbers, and in Poland or Germany - comma ",". Cells C102 and C104 are formatted like "Text" and dot there is not automatically converted into comma. Therefore if you have problems with masive errors after running SEP macro all you have to do is to change "0.1" into "0,1" in cells mentioned above.

Brilliant ! This solved the SEP / #VALUE problem for my dutch Excel. Everything seems to be working now, thanks a lot !


All times are GMT -4. The time now is 7:03 AM.

Forum Infrastructure by vBulletin 3.6.12 ©2000-2007, Jelsoft Enterprises Ltd.