fixed : why am I typing a TM-sign instead of a Euro-sign ?

Question :

Today, I had to type some text that included some financial figures, but for some reason I got a TM-sign on screen every time I typed the Euro-sign by pressing the key-combo [ALT]+[2].

I’ve never had this before.

What is wrong ?


Answer :

How you got this problem is unclear, but the solution is simple.

Have a look at the top menu bar (of the Finder), is there a US-flag next to the current time ?

If so, your keyboard is set to US-layout and in US-keyboardlayout the [ALT]+[2] key-combo will give the TM-sign (Trademark-sign) on screen.

To change that, do this :

  • click on the US-flag in the top menu bar (of the Finder)
  • in the pulldown menu, click on “Open Keyboard Preferences…”
  • in the window that opens, make sure the “Input sources”-tab is selected, then click on de + (Plus-sign) bottom left
  • from the list in the pulldown window that opens, choose “British” (UK-flag)
  • then click “Add”
  • back in the previous window, click on “(UK-flag) British” at the left to select it
  • then close the Preferences window by clicking the red button top left
  • then in the top menu bar (of the Finder) make sure there is a UK-flag
  • if there still is a US-flag, click on it and select the UK-flag from the pulldown menu

…then try typing the [ALT]+[2] key-combo in a text and see if it works

…that’s it ! enjoy 😉

Donate Button (MacManusNL)


fixed : change the Currency-format of only a few cells in Numbers (from iWork)

Question :

I’m using the Apple Numbers spreadsheet-app (from iWork) and I want to use multiple currencies in one spreadsheet (US dollars, GB pounds and Euros). I tried “Create / Change Custom Cell Format” from the “Format”-menu, but there the currency is set to default to my local currency (Euros) and I can’t change it…

This must be possible, right ?

But, how do I do it ?

Answer :

The trick is you should change the currency format of a (group of) cell(s) in the “Inspector”…

Here’s how to :

– in Numbers, select the cell or cells of which you want to change the currency

– then click on the “Inspector” (info-sign shaped button on the right of the upper bar of the spreadsheet-window)

– in the “Cells”-window that opens, choose the tab marked “42” (*)

– there, under “Cell Format” you should change the default “Automatic” to “Currency” and choose the one you want to use

That’s it !


(*) this is probably a subtile reference to “The Hitchhikers Guid To The Galaxy (H2G2)”, where 42 turns out to be the answer to “the ultimate question of life, the universe and everything”

Donate Button (all)