Input Masks

J

Jackie

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

Kathy

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
does? I cannot find the function if it exists.
 
O

onedaywhen

There's also the Microsoft Masked Edit ActiveX control, which ships
with some version of Excel.

--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top