I regularly paste hyperlinks into my spreadsheet, the hyperink is an ISBN
that generally starts with 0, which is of course ignored if the cell is
formatted to recognize it as a number. I formatted the cells for text so the
numbers pasted aren't changed but when the numbers pasted are in the form of
a hyperlink the formatting somehow reverts back and the 0 in the ISBN is
hacked off as if the cell had been formatted for a number. Any ideas on how
to avoid this?

When creating the original hyperlink, use:
'0123456
rather then:
0123456
in the Text to Display Field. If you copy/paste this hyperlink, leading
zeros will be retained.
--
Gary''s Student - gsnu200758


"Timmah18" wrote:

I regularly paste hyperlinks into my spreadsheet, the hyperink is an ISBN
that generally starts with 0, which is of course ignored if the cell is
formatted to recognize it as a number. I formatted the cells for text so the
numbers pasted aren't changed but when the numbers pasted are in the form of
a hyperlink the formatting somehow reverts back and the 0 in the ISBN is
hacked off as if the cell had been formatted for a number. Any ideas on how
to avoid this?