Using =Value(A1)
gives me an error #Value


maybe, if a formula is required:
=TEXT(A1,"0000-0000-000-000-")





--
Regards,
Tom Ogilvy

"Mallycat" wrote in
message ...

The apostrophe is a special character that turns the cell into Text.
You can convert it back to a number by using =value(A1). You will lose
the number formatting, but you can re-apply that with a custom format.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile:
http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553058