Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
fhswfhsfhs
|
Posted - 2007.09.26 22:34:00 -
[1]
Hello fellow tradesmen of Eve.
I'm having, quite a simple problem for you to help me out with. It's about the wallet export feature and opening and separate into columns in excel and getting the correct decimal punctuation.
I've managed to open the .csv file in excel and split the different columns to each it own.
The problem comes to, Excel doesn't recognize the numbers as numbers, but as text, due to the "american/international?" decimal seperation.
Example: What i get is: 5.00 What i want is: 5,00
How can I do this in a simple any easy way? My Excel is in english language and my windows are in swedish, if that would matter in any way.
Thanks alot for your help, I'd really appreciate it!
|
Dr Slurm
General Commodities
|
Posted - 2007.09.26 22:59:00 -
[2]
you could open it in a text editor and replace all the . with ,
I think part of your problem is your excel is a different language then your OS. <sig>
Tired of the inane ramblings of the incompetent? Click here </sig> |
Shadarle
|
Posted - 2007.09.26 23:50:00 -
[3]
Edited by: Shadarle on 26/09/2007 23:51:59 Or just find/replace in excel all . with ,
Using different language versions of programs than your OS can lead to weird things when working with windows since it tries to be too smart for its own good.
Tanking Setups Compared
Stacking Penalty / Resists Explained |
Treelox
Amarr Frontier Technologies
|
Posted - 2007.09.26 23:51:00 -
[4]
Edited by: Treelox on 26/09/2007 23:54:17 select the whole doc, right click --> "format cells" ---> first tab of this sub menu "numbers".
Look for the option that best fits what your after, you can also custom creat an option for yourself, but thats getting a bit more complex.
While the work arounds the 2 post above mention will remove your comma VS period issue they may not fix the issue of the numbers being viewed as alphaic instead numeric for the purpose of formulas
***edited to add the last paragraph*** -- http://www./sigs/Treelox/sig.png [orange]signature removed (change the zombie gagging sig) - please email us (with the signature URL) if you want to know why - Pirlouit([email protected] |
Shadarle
|
Posted - 2007.09.26 23:53:00 -
[5]
Originally by: Treelox select the whole doc, right click --> "format cells" ---> first tab of this sub menu "numbers".
Look for the option that best fits what your after, you can also custom creat an option for yourself, but thats getting a bit more complex.
I think he knows this, but I think he is saying this isn't working because the import he did has periods instead of commas. Thus excel doesn't recognize a lot of the numbers as numbers because 1,000,000 would show as 1.000.000. It has multiple periods in it, so it isn't a recognizable number.
Seems easy to fix with find/replace though as I said...
Tanking Setups Compared
Stacking Penalty / Resists Explained |
fhswfhsfhs
|
Posted - 2007.09.27 05:34:00 -
[6]
Thanks for all the input, I will look into it during the day and see if I get it to work!
Thanks alot!
|
Hoboid
|
Posted - 2007.09.27 08:36:00 -
[7]
i do the reformatting in an extra column with the following formula: WECHSELN(E2;".";",";1)
where E2 is ofc the source cell and what "wechseln" is called in your language i got no clue :P
|
fhswfhsfhs
|
Posted - 2007.09.27 14:42:00 -
[8]
Tried today and the "Find and replace" worked very well! Thank you all for the input.
Couldn't be happier than this :)
|
Motivated Prophet
Zerodot Schools Power Corrupts Industry's
|
Posted - 2007.09.27 16:00:00 -
[9]
tr/,./\t,/ That's just how I'd do it, anyway.
MP --
Proud steward of 47 billion isk in public money, and counting. Ask me about mineral compression! |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |