| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i convert £28.34 to 2834 pence
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA | Excel Worksheet Functions | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
Linear Mode
