fixed : free currency converter (or unit converter) for iOS

Question :
I used to have a currency converter app on my iPhone which was very handy when travelling the globe. But the free currency converter app that I used to use, doesn’t work with my current iOS version and is no longer available form the AppStore…

Do you have any recommendation ?


Answer :
With the introduction of iOS 18, Apple has. integrated all kinds of conversion options (including currency conversion) into the Calculator app. To use it, do this :
– open the Calculator.app on your iPhone (or iPad or Mac)
– when in the regular calculator mode, click on the Calculator-button (bottom left)
– from the popup list that appears, set the slider to the right (so ‘Convert’ will be chosen and turn orange)
– now the input field will be devided in two : an upper part with white digits and a lower part with grey digits ; the upper part is the input field, the lower part is the result field
– tip 1 : using the orange up/down-sign on the left, you can swap the currency
– tip 2 : using the grey up&down-icon next to the currencies, you can choose any currency you like
– tip 3 : after pressing the grey up&down-icon (next to the currency), you will get the option to convert not only currencies, but also all other sorts of values by choosing another orange chapter : Angle, Area, Data, Energy, Force, Fuel, Length, Power, Pressure, Speed, Temperature, Time, Volume or Weight ; you can scroll though the list or use the search field to find the currency (or other type of unit) you need
– so, after having chosen the sort of conversion you need, just key in the value and the converted value will be shown

That’s it !

enjoy 😉

fixed : USB-C memorystick for iPad Pro

Question :

I have an iPad Pro 2018 with a USB-C port, and I found out that I can connect a regular USB-stick using a USB-to-USB-C-adapter and then browse and use all files on the USB-stick from within the Folders.app on my iPad Pro. That’s great !

Now, since I only have USB-C ports on both my MacBook Pro and my iPad Pro,  I was wondering : are there any good USB-C memory sticks available for an affordable price ?

 

Answer :

The answer is simple : Yes, there are USB-C memorysticks that work great.

We have tested this one, that is both USB-C and USB compatible, that makes it even more versatile :

Topesel USB-C Memory Stick : buy it on Amazon UK / Amazon DE

And there are several alternatives (that we didn’t test) :

SanDisk Ultra Dual Drive Go USB-C : buy it on Amazon US / Amazon UK / Amazon DE

Verbatim Store&Go USB-C Flash Drive : buy it on Amazon US / Amazon UK / Amazon DE

Kenix on-the-go USB-C Memory Stick : buy it on Amazon UK / Amazon DE

Kootion USB-C Memory Stick : buy it on Amazon US / Amazon UK / Amazon DE

Meco Eleverde USB-C Memory Stick : buy it on Amazon US / Amazon UK / Amazon DE

Meco Eleverde 2-in-1 USB-C Memory Stick : buy it on Amazon US / Amazon UK / Amazon DE

enjoy 😉

fixed : copied Excel data only shows zeros instead of original values

Question :

I have this data-range in MS Excel that I want to copy from one page to another, but when I do, in the area that I want to copy to, all cells are filled with zeros…

…the original data has disappeared…

How can I fix this ?

Answer :

Just use the “Paste Special”-option from the Edit-menu, like this :

– in MS Excel, go to the data that you want to copy

– select the range of data you want to copy

– press CMD + C (or choose “Copy” from the Edit-menu)

– then go to the area you want to copy the data to, and select the upper-left cell of the area you want the copied data to appear in

–  then press SHIFT + CMD + V (or choose “Paste Special” from the Edit-menu)

– in the pop-up window that appears, select “Values” (the option third from the top) instead of “All” (which was the first option from the top), and click “OK”

– now the original data will appear

…that’s it !

Enjoy ! 😉

Donate Button (all)

fixed : copy a row into a column (or a column into a row) in MS Excel

Question :

I have this column full of data in MS Office’s Excel, and now I need the exact same data range in another spreadsheet, but this time as a row…

Do I really need to re-type all data ?

Isn’t there an easier solution ?

Answer :

Yes, there is a far simpler way to copy data from a row into a column (and vice versa) in Excel.

You can just copy & paste, or “Paste Special” to be exact… it goes like this :

– in Excel, select the range of cells you want to use (or copy)

– then press the CMD + C key-combo (or select “Copy” from the Edit-menu)

– then go to the page (a.k.a. “sheet”) you want the copy the data to, and select the upper-left cell of the area you want the copied data to appear in

– then press the SHIFT + CMD + V key-combo (or select “Paste Special” from the Edit-menu)

– …and in pop-up window that opens, put a check-mark in front of “Transpose” and click “OK”

– now the data from your original row (or column) will ‘magically’ appear as a column (or row)…

…that’s it !

enjoy ! 😉

Donate Button (all)