Tom was the only one to give you the format as well, but the code

Range("D33").value = .08
Range("D33").Numberformat = "0%"

can be combined with

Range("D33").value = "8%"

Excel does the rest.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Michael" wrote in message
...
I'm having trouble learning Macros. I need to toggle a single cell (d33)
between a value of 8% and blank.

ALSO, I'd love a better site for help topic. MS really dropped the ball
on this topic.

Thanks,
Michael
---