Help needed - I want to convert a number to text with a number

New Contributor

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.

2 Replies
best response confirmed by Lee_Baxter (New Contributor)

@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




Got the issue resolved, thank you so much.