Prevent use of Colon

  • Thread starter Thread starter universal
  • Start date Start date
U

universal

Hello all,

Is there any way to prevent a user from entering a colon in a cell, as
this converts the format to Date and makes things very complicated once
I receive all these spreadsheets back from the users.

Ive disabled the colon with ascii commands on the user form that
'feeds' the data. Though, perhaps there's also some way of doing this
on the worksheet itself with validation that Im not aware?

Many Thanks
Ed
 
What should be entered instead of a colon? A period? You could have a macro
that runs
when you open the workbook that change autocorrect temporarily and if they
enter : instead it will
be a period or something else..

I also assume you meant time when you said date?
 
Entering something like 12:10 will only result in a time entry if the cell
has no number format, i.e., the General number format. But if you give it a
number format ahead of time that won't happen.
 
Thanks guys,

Peo, you're right, I meant Time not Date!

Also, about setting the number format for each cell, a user who enters
12:10 (meaning 12 hours 10 minutes) will not see that if Ive set a
number format first (it appears as 0.51). This will be very confusing
for my users, and hence it would be nice if an entry of 12:10 appeared
as 12.10 (or 12.1) or restricted them using ':' at all.

Any ideas?
 
Back
Top