Custom format pence

Hi,
I have been trying to create a custom format to display currency as pence. ie. in a cell i have the value 0.8 but i want to display it as 80p. I have only managed so far to get .80p (note the period) by using .00p as the custom format code. Is there a way to get rid of the . ???
Thanks in advance,
Hello1 (well im not gonna say my real name am i ) lol

Hi,
I have been trying to create a custom format to display currency as pence. ie. in a cell i have the value 0.8 but i want to display it as 80p. I have only managed so far to get .80p (note the period) by using .00p as the custom format code. Is there a way to get rid of the . ???
Thanks in advance,
Hello1 (well im not gonna say my real name am i ) lol

Hi,

I note that you have used a frivolous response to your location. We like to know for various reasons, but it's enough that we ask. We expect people to respect the question and ask honestly.

Please PM the administrator, apologise for being frivolous give him a sensible location, and ask him if he would kindly change it.

Regards

ill change it if u really want but i think there should really be an option for hiding your location.

ps. is your avatar a mandelbrot set???

You're entitled to think whatever you wish, but if we didn't want to know the location, we wouldn't ask. Those are the requirements of the forum and if you really don't want to abide by them then there is no compulsion to join.

And yes, my avatar is a mandelbrot set - well spotted.

Rgds

"Rocketman", do you think your last post contributes to helping posters improve their XL knowledge ?
If you want to moderate, contact admin. If not, maybe these kind of remarks could be sent in a PM?