I have a column of numbers (ex. 123456) that I want to convert to the following format 12-34-56. Is there an easy way to do this?

Question

I have a column of numbers (ex. 123456) that I want to convert to the following format 12-34-56. Is there an easy way to do this?

Anonymous

i have a column of numbers (ex. 123456) that I want to convert to the following format 12-34-56. Is there an easy way to do this?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

i have a column of numbers (ex. 123456) that I want to convert to the following format 12-34-56. Is there an easy way to do this?

Assuming that your Column Of Numbers are indeed numbers and not text then:-

- highlight the cells you want to change

- CTRL + 1 to open the window called Format Cells

- then format the required cells as shown in the image below i.e. ##-##-##

![](https://learn-attachment.microsoft.com/api/attachments/403d7894-bc44-46a9-886a-44df676a52fd?platform=QnA

Answer 2

If it is for display purposes only, apply the custom number format 00-00-00 to the cells.

If you want the values as text: let's say your numbers are in B2:B50.

In C2, enter the formula =TEXT(B2:B50, "00-00-00")

This will spill to C2:C50.

If you want to get rid of the formulas, copy C2:C50, then paste as values.

Share via

I have a column of numbers (ex. 123456) that I want to convert to the following format 12-34-56. Is there an easy way to do this?

0 additional answers