Thread: Working out energy bills
View Single Post
Old 13-09-2024, 16:46   #5
Paul
Dr Pepper Addict
Cable Forum Team
 
Paul's Avatar
 
Join Date: Oct 2003
Location: Nottingham
Age: 62
Services: Aquiss FTTP (900M), Sky Q TV, Sky Mobile, Flextel SIP
Posts: 29,791
Paul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered stars
Paul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered starsPaul is seeing silvered stars
Re: Working out energy bills
Quote:
Originally Posted by Hom3r View Post
Can anyone solve this so it will show £p?
All I do is set that value 29.09, and divide the multiplied result by 100 for £.

You can format cells to display how you want as well (inc dp's) so I display it as 29.09p
__________________

Baby, I was born this way.
Paul is offline   Reply With Quote