division symbol

tutor · Nov 15, 2004

how do i insert a division symbol in Excel 2000?

duane · Nov 15, 2004

/

as in a1/a2 is a1 divided by a

Alan · Nov 15, 2004

enter a ' before the /
Regards,

Alan · Nov 15, 2004

Or if you mean a ÷

use = CHAR(247)
eg to show 25 divided by 5 = 5 as text
=25&CHAR(247)&5&"=5"
Regards,