shahin
Active Member
Is there any way I can replace this "-857663" with "+34-94-857603". If you select any cell containing negative number in front, you may notice that the very number is visible in it's different form in address bar. For example, in a cell the number looks like "-857663" but in the address bar it looks like "=34-94-857603". The expected output is "+34-94-857603". Thanks for your observation. There is an excel file in the attachment to bring the clarity, If I failed to make myself clear.