Input Mask

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimmy Clay - 30 Nov 2004 18:40 GMT

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.

Signature

Jimmy Clay

Read free ebooks !!!!!
Go to my web page:
http://thesongofthecoyote.tripod.com/

Reply to this Message

Frank Kabel - 30 Nov 2004 18:44 GMT

Hi
you could use a custom format such as
"SN"0000

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Does Excel have an Input Mask function?
>
[quoted text clipped - 9 lines]
> Go to my web page:
> http://thesongofthecoyote.tripod.com/

Reply to this Message

Jimmy Clay - 30 Nov 2004 21:16 GMT

You are right, that works.

Signature

Jimmy Clay

Read free ebooks !!!!!
Go to my web page:
http://thesongofthecoyote.tripod.com/

> Hi
> you could use a custom format such as
[quoted text clipped - 21 lines]
>> Go to my web page:
>> http://thesongofthecoyote.tripod.com/

Reply to this Message

CLR - 01 Dec 2004 01:16 GMT

Maybe Concatenation............

="SN"&A1

Vaya con Dios,
Chuck, CABGx3

> Does Excel have an Input Mask function?
>
[quoted text clipped - 9 lines]
> Go to my web page:
> http://thesongofthecoyote.tripod.com/

Reply to this Message