how can i convert £28.34 to 2834 pence

  • Thread starter Trevor Shuttleworth
  • Start date
T

Trevor Shuttleworth

Well, you could multiply it by 100 and format it as:

Format | Cells... | Number tab | Category: Custom Type: 0 "pence"

That's zero, space, and the word "pence" in quotes

Should display £28.34 into 2834 pence

Regards

Trevor
 
T

Trevor Shuttleworth

But that would turn the result into text which would preclude arithmetic if
that is desired. The custom format shows the result as pence but you can
still use it in calculations

Regards

Trevor


If that were to be in cell A1:

=A1*100 & " pence"

HTH,
-Sean
 
Top