Kindly Request for Excel Help in Cell Formating
Closed
grampsgary
Posts
2
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 20, 2013
-
Mar 20, 2013 at 05:01 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 21, 2013 at 04:24 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 21, 2013 at 04:24 PM
Related:
- Kindly Request for Excel Help in Cell Formating
- Excel date format dd.mm.yyyy - Guide
- Submit request free fire - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- Request birthday change facebook locked account - Guide
3 responses
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 20, 2013 at 05:07 PM
Mar 20, 2013 at 05:07 PM
Hi Gary,
Use the following steps to turn the link again to Hyperlink:
1. Paste the website address in the cell.
2. Right click the cell.
3. Select "Hyperlink...".
4. Click OK, the address will again change to Hyperlink
Do reply with results.
Use the following steps to turn the link again to Hyperlink:
1. Paste the website address in the cell.
2. Right click the cell.
3. Select "Hyperlink...".
4. Click OK, the address will again change to Hyperlink
Do reply with results.
grampsgary
Posts
2
Registration date
Wednesday March 20, 2013
Status
Member
Last seen
March 20, 2013
Mar 20, 2013 at 09:02 PM
Mar 20, 2013 at 09:02 PM
Thanks for trying to help. I appreciate your assistance
but, I still have a problem
I think that I need to format the cell
I would appreciate any other suggestions
Kindly thanks for your time and help
Gary
but, I still have a problem
I think that I need to format the cell
I would appreciate any other suggestions
Kindly thanks for your time and help
Gary
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Mar 21, 2013 at 04:24 PM
Mar 21, 2013 at 04:24 PM
Hi Gary,
If the address does not begin with any qualifier for websites such as "www" or "[http://]" it is difficult for Microsoft Excel to identify it as address. For example: the address "en.kioskea.net" when pasted as plain text or without any formatting the address will not be detected as a webpage by Microsoft Excel. However, if I add the prefix "[http://]" to it, it will change to a webpage hyperlink. So, the first method you can use to change the address is by adding the prefix "[http://]" to it. Second method is to convert it to a hyperlink using the steps provided in my previous post. The only difference I recommend this time is to put the same address in "Address" field of the "Edit Hyperlink" dialog box. You can check the below mentioned link for a pictorial view of this step:
http://s24.postimg.org/64j0f1ied/image.jpg
Do reply with results.
Thanks & Regards
Zohaib R
#iworkfordell
If the address does not begin with any qualifier for websites such as "www" or "[http://]" it is difficult for Microsoft Excel to identify it as address. For example: the address "en.kioskea.net" when pasted as plain text or without any formatting the address will not be detected as a webpage by Microsoft Excel. However, if I add the prefix "[http://]" to it, it will change to a webpage hyperlink. So, the first method you can use to change the address is by adding the prefix "[http://]" to it. Second method is to convert it to a hyperlink using the steps provided in my previous post. The only difference I recommend this time is to put the same address in "Address" field of the "Edit Hyperlink" dialog box. You can check the below mentioned link for a pictorial view of this step:
http://s24.postimg.org/64j0f1ied/image.jpg
Do reply with results.
Thanks & Regards
Zohaib R
#iworkfordell
