T
Timmah18
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?
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?