SOLVED

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

Copper 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 (Copper Contributor)
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

mtarler_0-1638997383058.png

 

 

Got the issue resolved, thank you so much.
1 best response

Accepted Solutions
best response confirmed by Lee_Baxter (Copper Contributor)
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

mtarler_0-1638997383058.png

 

 

View solution in original post