Displaying a custom formatted number
 

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?

Displaying a custom formatted number
 

In .com, wx4usa
spake thusly:

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.

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

--
dman

Displaying a custom formatted number
 

On Jul 30, 5:42 pm, Dallman Ross <dman@localhost. wrote:
In .com, wx4usa
spake thusly:

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.

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

--
dman

Thank you, very much!

Displaying a custom formatted number
 

In . com, wx4usa
spake thusly:

Thank you, very much!

You're welcome!

--
dman