Retain Format when refering to another Cell

Hi,

here is something unique, now I know what i need to do in VBA to get this to work but i was hoping there was an easier way

Please Login or Register  to view this content.

in G2 = 3000
in H2 = 0.3333333

the CODE will prompt a display of |3000 (0.33333)|

i would like the display to be |3000 (33%)|

is this possible?

Sweep,

this is bloody marvelous

works perfectly, thank you