Add % sign to numbers

B

bdcrisp

well, if cell a1's value = 23.34

CELLS(1,1).VALUE = CELLS(1,1).VALUE & "%"

thats i
 
B

Bob Phillips

Do you want real percentages? If so, enter as a number relative to 1 (i.e.
23.45% is entered as .2345) and format as percentage.

Or even easier, just type in 23.45%.

--

HTH

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

clui said:
How do I add a % sign to my numbers? For example, 23.45 becomes 23.45%.
Thanks!
Click to expand...
creating financial statements
 
Top