Input Masks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does excel have input masks the same way that access does? I cannot find the function if it exists.
 
Hi Jackie,

No Excel does not have an Imput Mask the same as access.
But you can format the type of date that goes in a cell.
Try this.
High Light the cell and right click your mouse
Select format cell.
Choose type of data that is enterred
Choose how that data is displayed.

You can also specify data types in the Validation window.
Goto Data
Goto Validation
Select types of data.

Good luck
Kathy
-----Original Message-----
Does excel have input masks the same way that access
Click to expand...
does? I cannot find the function if it exists.
 
There's also the Microsoft Masked Edit ActiveX control, which ships
with some version of Excel.

--
 
Back
Top