two ways

You can make your own format for cells

format-cells tab numbers select custom and make a mask like
"0,00mA"

and by VBA format$(yournumber,"0,00mA")


--
Dnereb
------------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182
View this thread: http://www.excelforum.com/showthread...hreadid=398079