Excel Query - numbering

  originalmiscellany 00:51 05 Aug 2006

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);

  seldom seen 08:38 05 Aug 2006

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.


  VoG II 08:43 05 Aug 2006

click here should get you started.

  originalmiscellany 09:12 05 Aug 2006

THat's solved it perfectly.

Many thanks

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

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 ?