Thread: I want to extract the pence from a currency sum
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default I want to extract the pence from a currency sum
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
Reply With QuoteReply With Quote