how can i convert £28.34 to 2834 pence
 

how can i convert £28.34 to 2834 pence
 

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


"Rina" wrote in message
...

how can i convert £28.34 to 2834 pence
 

If that were to be in cell A1:

=A1*100 & " pence"

HTH,
-Sean

Trevor Shuttleworth wrote:
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


"Rina" wrote in message
...

how can i convert £28.34 to 2834 pence
 

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


"S Davis" wrote in message
oups.com...
If that were to be in cell A1:

=A1*100 & " pence"

HTH,
-Sean

Trevor Shuttleworth wrote:
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


"Rina" wrote in message
...