Remember you have to pre-format the cell as Text.

Format the cell as text first, then type your long string of numbers.

(It's never failed for me.)

bumble78 wrote:

Thanks, the apostroy thing worked, the formating as text did not.
Thanks for your help.:)

Joe

--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=572883

--

Dave Peterson