Excel Query - numbering

  originalmiscellany 00:51 05 Aug 06
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 06

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 06

click here should get you started.

  originalmiscellany 09:12 05 Aug 06

THat's solved it perfectly.

Many thanks

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

Sony Xperia XZ Premium review: Hands-on with the new 4K HDR phone with Motion Eye camera and Snapdr5…

1995-2015: How technology has changed the world in 20 years

Best laptop for design and art 2017: we test Apple, Dell, HP, Lenovo and Microsoft's best models…

CarPlay tips & troubleshooting guide: CarPlay tips & troubleshooting guide: Get the most from…