If you want to do this with a formula you can download the MOREFUNC
addin and use the NBTEXT function, then you just need
=NBTEXT(A1)
MOREFUNC addin is free, look here
http://www.rhdatasolutions.com/morefunc/
otherwise you need to use VBA
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=503754