Displaying a custom formatted number

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

wx4usa

I would like a person to enter a number up to 2 digits, followed by a
dash "-" then 2 more digits.

Example: enter 23-67 or 45-09 or 01- 35 is entered into a cell and
excel wants to convert it to dates and times etc.

How do I do this?
 
wx4usa said:
Example: enter 23-67 or 45-09 or 01- 35 is entered into a cell
and excel wants to convert it to dates and times etc.
Click to expand...

Just format the cells to Text and the values entered will no
longer look like dates.
 
Back
Top