Kako pretvoriti tisoč vejic v decimalna mesta ali obratno v Excelu?
Avtor: SonceZadnja sprememba: 2020-12-21
Ko delate pri kakšni mednarodni reviziji, ste morda naleteli na to težavo pri pretvorbi tisoč vejic v decimalna mesta ali obratno na Excelovem delovnem listu. Imate kakšen trik pri reševanju te naloge?
Če imate seznam številk, kot je prikazano na sliki spodaj, zdaj želite vejice (ločilo tisočic) pretvoriti v decimalna mesta, decimalna mesta (decimalno ločilo) pa v vejice, lahko uporabite funkcijo Option.
klik file > možnosti, potem v Možnosti programa Excel dialog, kliknite Napredno v levem podoknu, nato v desnem delu, UrejanjeMožnosti skupina, počistite Uporabite sistemsko ločilo, nato vnesite vejico v Decimalni separator namesto na decimalno vejico vtipkajte in vnesite decimalno vejico na Tisoč separator za zamenjavo vejice.
This comment was minimized by the moderator on the site
Your clickbait in the heading says "convert" and what you go on to describe is something totally different from conversion.
In fact, after carrying out the steps you describe all the commas and dots in the cells stay exactly the same as before,and you have accomplished NOTHING resembling conversion.
What your steps do, is force Excel to interpret the contents in the cells different, as if dots and commas were the wrong way around.
And what REALLY sucks with your brainless advice here, is that the poor idiot who might be stupid enough and believe you, and actuallytake the action you recommend, will find that none of their other excel files work anymore as excel will interpret dot and commathe other way around in each and every file they open, so they might have worked around their difficulty for that one file,but the other 500 excel files on their hard drive were broken by your irresponsible idiot advice. Sheeweeeshhhhh