I have 2 columns in my spreadsheet.One column has currency in, e.g. £23.40 and in the other column I'd like to translate the currency into numbers, e.g. twenty three pounds fourty pence.Is this possible and if so how?!Cheers (as ever);
Remove 'currency' formatting from the cell to display numbers only, using the formatting menu from the main menu bar.F1 or office assistant will explain in detail.Al
click here should get you started.
THat's solved it perfectly.Many thanks
This thread is now locked and can not be replied to.
OnePlus 5 review
See the work of famous artists playing with toys
iPad Pro 10.5in (2017) review
Comment faire une capture d’écran sur un Mac ?
© Copyright 2017 IDG UK. All Rights Reserved.