Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
There's no masking function. If you apply the custom format "ABC"#, it will
display with your prefix. But that prefix isn't part of the data. On Wed, 06 Oct 2004 23:41:13 +0100, Peter wrote: Hi Can anyone please tell me if Excel has the equivalent of the Mask in Access? Also, is it possible to format a cell so that if a number is entered e.g. 123, it is automatically prefixed with three letters? e.g. ABC123 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Equivalent of Access "Load" Event? | Excel Discussion (Misc queries) | |||
Input Mask | Excel Worksheet Functions | |||
What is the Access equivalent of Excel's COUNTIF? | Excel Discussion (Misc queries) | |||
Input Mask | New Users to Excel | |||
Password mask | Excel Programming |