B bdcrisp Dec 8, 2003 #2 well, if cell a1's value = 23.34 CELLS(1,1).VALUE = CELLS(1,1).VALUE & "%" thats i
B Bob Phillips Dec 8, 2003 #3 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! ------------------------------------------------ ~~Now Available: Financial Statements.xls, a step by step guide to Click to expand... creating financial statements
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! ------------------------------------------------ ~~Now Available: Financial Statements.xls, a step by step guide to Click to expand... creating financial statements
