Ellis - profile

Ellis · Feb 21, 2023

Hi, struggling with a formula for converting a currency field into minor units.Example: Formula field adding two currency values (£50.45 & £40.20) gives value £90.65. I need a formula that returns this value as 9065 - but I cannot work it out.In Exce...

Ellis · Feb 22, 2023

Thanks Ron, it doesn't quite (my fault, bad example) but I now realise why nobody has asked this question before as the answer is blindingly obvious and I feel like an idiot for asking it! I was looking for a way more complicated solution than requir...

User Statistics

User Activity

Convert currency with decimals into minor units number

Re: Convert currency with decimals into minor units number