• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Phone numbers with "+" sign in front gets a different form in an excel file

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.
 

Attachments

  • demo.xlsx
    9.8 KB · Views: 6
Back
Top