asked on

Editing excel file

Hello Experts,

I have an excel file that has a column of mobile numbers. The number are showing as (189) xxx-xxxx. I want to add this to the phone number +1 and modify the cell to +1-189-xxx-xxxx. what I try to put +1 and modify the cell and click enter to go to the cell below I the cell behaves as if I am adding the contents from the cell below. Its weird.

Is there another format other than excel or csv I can open it and make the changes on the phone list.

Can you please help me.

Glowman

Try adding a single quote before the +1
the + is acting as a mathematical operator

Saurabh Singh Teotia

Another option is to format the column as text-->Press ctrl+1-->and format cell as text and you will be good on whatever telephone number you enter...This will remain the way it is

Saurabh...

smart Z

ASKER

I need the plus as I will be updating the phone numbers with Plus sign in active directory. How can I stop excel to behave this way

smart Z

ASKER

I made the cell as text format when I do +1-231-xxx-xxx and go to the next cell if changes the number.

but if I do +1-+1-231-xxx-xxx and take the cursor to the last digit and press enter it remains. this is terrible

ASKER CERTIFIED SOLUTION

Saurabh Singh Teotia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tom Farrar

Is it necessary to change the area code from (713)555-5555 to -713-555-5555?

smart Z

ASKER

Ok thanks guys. This is good to know but not exactly what I was thinking.