Found the answer from Dave Peterson's reply on 7/17/06 to a similar
question

If the hyphens are part of the number format (not part of the value),
then
Select the range
format|cells|Number tab
custom category
type: 000000000
in the "Type:" box

If the hyphens are really part of the data (liked they were typed in),
then
Select the range
edit|replace
what: - (hyphen)
with: (leave blank)
replace all


--
annep
------------------------------------------------------------------------
annep's Profile: http://www.excelforum.com/member.php...o&userid=18851
View this thread: http://www.excelforum.com/showthread...hreadid=568622