I want to extract the pence from a currency sum
Hi Julie,
Am Wed, 1 Feb 2017 08:24:05 -0800 (PST) schrieb JulieS:
I am working on a sheet where I need to breakdown a currency value into pounds and pence in separate columns without the pence showing the decimal point.
i.e. 123.58 in B1 becomes 123 in C1 and 58 in D1
try in C1:
=INT(B1)
and in D1:
=MOD(B1,1)
Regards
Claus B.
--
Windows10
Office 2016
|