| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to extract the pence from a currency sum
On Wednesday, February 1, 2017 at 5:19:54 PM UTC, Claus Busch wrote:
Hi, Am Wed, 1 Feb 2017 09:07:24 -0800 (PST) schrieb JulieS: Thanks Claus, that works when I have a number but when the decimal is 00, it just populates as 0, and I don't know how to populate the second zero, any ideas? format D1 with custom numberformat 00 Regards Claus B. -- Windows10 Office 2016 Claus - Thank you so much! It works, you star! I really appreciate this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pence per mile | New Users to Excel | |||
| how can i convert £28.34 to 2834 pence | Excel Worksheet Functions | |||
| WHY IS MY CURRENCY SUM ONE PENCE OUT? | Excel Worksheet Functions | |||
| How do I add Pounds, Shillings and Pence? | Excel Discussion (Misc queries) | |||
| Pence field to currency? | Excel Worksheet Functions | |||
![JulieS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
