Hi

My inventory system has storage locations that follow the format 1A1,
1A2 etc. When I get to those with an E in them excel displys them as
an above.

How can I get it to show 13E2, not 1.30E+03?

Thanks
Andy


--
hywt
------------------------------------------------------------------------
hywt's Profile: http://www.excelforum.com/member.php...o&userid=27656
View this thread: http://www.excelforum.com/showthread...hreadid=487913