Excel Query - numbering

  originalmiscellany 00:51 05 Aug 2006
Locked

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.

Al

  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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

HomePod review

Streaming : Netflix ou Amazon Prime Video ?