How to get euro symbol using spreadsheet
I just uploaded some listings by spreadsheet and though I typed € in Excel, when I checked the listings all the euro signs were a little square instead
I tried to upload in Unicode txt instead of normal txt, but that didn't work at all.
For now I have replaced € with Euro, but I know I have uploaded € before.
Can anyone remind me how to do it?
Re: How to get euro symbol using spreadsheet
If entering in HTML editing mode, use: €
Re: How to get euro symbol using spreadsheet
Alt code for Euro symbol is 0128 €
1 Attachment(s)
Re: How to get euro symbol using spreadsheet
Thanks, I now load euro into my spreadsheet listings by typing:
Attachment 62486
(Obviously, if I type that in this forum, it will come out as €, hence the image
Re: How to get euro symbol using spreadsheet
Blame the Yanks. They invented ASCII (guess what the 'A' stands for). Even the British pound wasn't included. The Euro wasn't introduced until 1999, so without a crystal ball the omission is excusable. Whereas the British pound sterling goes back to before William the Conq!
But why would they consider other currencies? I've even been asked by the Vice President of a large corporation, about to make his first tour of Europe, "Say, do you use dollars in London?". Admittedly this was in Florida. Bless! :)
Re: How to get euro symbol using spreadsheet
Quote:
Originally Posted by
johnwash1
Blame the Yanks. They invented ASCII (guess what the 'A' stands for). Even the British pound wasn't included. The Euro wasn't introduced until 1999, so without a crystal ball the omission is excusable. Whereas the British pound sterling goes back to before William the Conq!
But why would they consider other currencies? I've even been asked by the Vice President of a large corporation, about to make his first tour of Europe, "Say, do you use dollars in London?". Admittedly this was in Florida. Bless! :)
Actually, the £ symbol (ASCII 0163) has been a part of the ASCII character set used in the US at least since 1987 (along with a few other currency symbols). This was over a decade before the Euro was even in use. Even earlier character sets used in the US contained £ characters, although it wasn't part of the earliest USASCII (c. 1970, which only contained characters present on US typewriters and teletype printers). Perhaps you'll recall that, before Unicode, each region (and regional keyboard type) had its own ASCII/ANSII character set/code page that contained the most commonly used national characters for each region. Extensions added more characters as time progressed, until today's unified character set gradually began to be implemented in the mid 1990s. I dealt with those evolving standards throughout that time in my publishing job.
As to the VP from Florida - yeah, I wouldn't dispute that. Corporate types certainly do tend to "rise to the level of their incompetence" :)
Re: How to get euro symbol using spreadsheet
Quote:
Originally Posted by
rocks2dust
Actually, the £ symbol (ASCII 0163) has been a part of the ASCII character set used in the US at least since 1987 (along with a few other currency symbols). This was over a decade before the Euro was even in use. Even earlier character sets used in the US contained £ characters, although it wasn't part of the earliest USASCII (c. 1970, which only contained characters present on US typewriters and teletype printers). Perhaps you'll recall that, before Unicode, each region (and regional keyboard type) had its own ASCII/ANSII character set/code page that contained the most commonly used national characters for each region. Extensions added more characters as time progressed, until today's unified character set gradually began to be implemented in the mid 1990s. I dealt with those evolving standards throughout that time in my publishing job.
For me, it is the unreliability of symbols when uploading on spreadsheet.
European umlauts and accents, Polish zloti seem OK, but then I see, maybe after relisting, that the symbol has been scrambled on my listings.
It is not only euro, sometimes £, and even ', never mind half and quarter that get scrambled.
Re: How to get euro symbol using spreadsheet
Quote:
Originally Posted by
rocks2dust
Actually, the £ symbol (ASCII 0163) has been a part of the ASCII character set used in the US at least since 1987 (along with a few other currency symbols). This was over a decade before the Euro was even in use. Even earlier character sets used in the US contained £ characters, although it wasn't part of the earliest USASCII (c. 1970, which only contained characters present on US typewriters and teletype printers). Perhaps you'll recall that, before Unicode, each region (and regional keyboard type) had its own ASCII/ANSII character set/code page that contained the most commonly used national characters for each region. Extensions added more characters as time progressed, until today's unified character set gradually began to be implemented in the mid 1990s. I dealt with those evolving standards throughout that time in my publishing job.
As to the VP from Florida - yeah, I wouldn't dispute that. Corporate types certainly do tend to "rise to the level of their incompetence" :)
Yes, not the original 7-bit ASCII though. I do indeed recall those things. The regional code pages were a bit of a kluge, it took a long time for Unicode to come along, but not surprising considering how precious storage was. I've even worked on machines where storage was conserved by using a compressed alphanumeric code that squeezed 3 characters into 16 bits!
I thought the VP was pulling my leg, but then I remembered he didn't have a sense of humour. To be fair, it was going to be the first time he even ventured out of the state, let alone the country!