Pestomania
Active Member
- Joined
- May 30, 2018
- Messages
- 332
- Office Version
- 365
- Platform
- Windows
Hello.
I have cells that contain dates in the following formats:
"9/13-"
"9/13-9/14"
"-9/14"
What I am trying to determine is if I can force the "hyphen" into the cell. So if I type:
"9/13"
The format will auto-update to:
"9/13-"
I formulas that are based on that "-" being there.
How can I do this if someone forgets to place the hyphen?
I have cells that contain dates in the following formats:
"9/13-"
"9/13-9/14"
"-9/14"
What I am trying to determine is if I can force the "hyphen" into the cell. So if I type:
"9/13"
The format will auto-update to:
"9/13-"
I formulas that are based on that "-" being there.
How can I do this if someone forgets to place the hyphen?