Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Input Mask
Does Excel have an Input Mask function?
I took the certification test and one of the questions, if I remember it correctly, wanted me to change a column of numbers so they had "SN" in front of them. I think perhaps I was getting Excel confused with Access, but I kept looking for a way to create an input mask. -- Jimmy Clay Read free ebooks !!!!! Go to my web page: http://thesongofthecoyote.tripod.com/ |
#2
|
|||
|
|||
Hi
you could use a custom format such as "SN"0000 -- Regards Frank Kabel Frankfurt, Germany "Jimmy Clay" schrieb im Newsbeitrag ... Does Excel have an Input Mask function? I took the certification test and one of the questions, if I remember it correctly, wanted me to change a column of numbers so they had "SN" in front of them. I think perhaps I was getting Excel confused with Access, but I kept looking for a way to create an input mask. -- Jimmy Clay Read free ebooks !!!!! Go to my web page: http://thesongofthecoyote.tripod.com/ |
#3
|
|||
|
|||
You are right, that works.
-- Jimmy Clay Read free ebooks !!!!! Go to my web page: http://thesongofthecoyote.tripod.com/ "Frank Kabel" wrote in message ... Hi you could use a custom format such as "SN"0000 -- Regards Frank Kabel Frankfurt, Germany "Jimmy Clay" schrieb im Newsbeitrag ... Does Excel have an Input Mask function? I took the certification test and one of the questions, if I remember it correctly, wanted me to change a column of numbers so they had "SN" in front of them. I think perhaps I was getting Excel confused with Access, but I kept looking for a way to create an input mask. -- Jimmy Clay Read free ebooks !!!!! Go to my web page: http://thesongofthecoyote.tripod.com/ |
#4
|
|||
|
|||
Maybe Concatenation............
="SN"&A1 Vaya con Dios, Chuck, CABGx3 "Jimmy Clay" wrote in message ... Does Excel have an Input Mask function? I took the certification test and one of the questions, if I remember it correctly, wanted me to change a column of numbers so they had "SN" in front of them. I think perhaps I was getting Excel confused with Access, but I kept looking for a way to create an input mask. -- Jimmy Clay Read free ebooks !!!!! Go to my web page: http://thesongofthecoyote.tripod.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i input euros and have it convert into dollars in the same. | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
input order | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) |