Copied hyperlinks

  • Thread starter Thread starter Timmah18
  • Start date Start date
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?
 
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.
 
Back
Top