Forum Discussion

MichaelaT2330's avatar
MichaelaT2330
Copper Contributor
Mar 07, 2023

How to format cells to include dashes within the number input?

I've been asked to update the formatting of cells containing a 10-character value from XXXXXXXXXX to XX-XX-XXXX-XX. I'm hoping to format the cell so that it does it automatically. I bet I can custom format the cells to do this, but I'm not sure how to format it so that it inserts dashes within the value.

excel

2 Replies

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Mar 07, 2023

      MichaelaT2330 

      Excel does not support custom formats for text values.

      You can either use a formula in another cell, or use a macro to convert the value in the cell itself.

Resources