Matching the cell to the function bar

[Tran2020]

Hello,

I have a column of phone numbers and it is display like the following: 920-123-4567

The function bar displays the cell like the following: 9201234567. without the dashes.

How can I make it match? I want the function bar to have the dashes like the cell.

Thank you!

[mikeava]

Did you format the cell in any way? If you just type 920-123-4567 it should be the same in both the cell and formula bar

[Tran2020]

The cell was a custom format from a different cell. I did not type them in. Is there anything else I can try?

Thank you

[mikeava]

If the column is only phone numbers then the only thing I can think of is this. (little pain but it will get what you want)

Click on your column
Copy to new sheet or new tab
Go to Data tab
Click on Text to Columns
Click on Fixed Width
Click Next
Click after the 0 in 920 and after the 3 in 123 (should see a line between)
Finish
Now the cells will be broken up 920 in 1 cell 123 in the next and 4567 in the next
Click on cell next to 4567 (Col D for example)
Then use Concatenate with a dash between the cells like =CONCATENATE(A6,"-",B6,"-",C6)
Copy that column
Paste as Values to your original data

[Tran2020]

Thanks mikeava. I will try that and let you know.

[Fluff13]

Another option.
You could put this formula in an unused column, fill down & then copy/paste as values
=TEXT(A2,"000-000-0000")

[Tran2020]

I need “ph” in front of the number. Can I still do this?

Thank you!

[Fluff13]

Yup, like
="Ph"&TEXT(A2,"000-000-0000")

[Tran2020]

Yup, like
="Ph"&TEXT(A2,"000-000-0000")

Thank you all! mikeava worked for me.