Dec 08 2021 03:07 AM
How do I change a row of numbers, so it starts with a word linking to that number?
Example: 0766693905 must display as Tel:0766693905 in the cell.
Dec 08 2021 01:03 PM
Solution@Lee_Baxter if you need the value of the cell to be that way, create a column with a formula like ="Tel:"&A1:A1000
if you just need the display to look that way then use a Custom Formatting like "Tel:"0
Dec 09 2021 02:57 AM
Dec 08 2021 01:03 PM
Solution@Lee_Baxter if you need the value of the cell to be that way, create a column with a formula like ="Tel:"&A1:A1000
if you just need the display to look that way then use a Custom Formatting like "Tel:"0