View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default how to format data with an input mask like ss# (***-**-****)

Try Format Cells - NUmber - Custom

###-###-###-##-##

--
HTH,
Barb Reinhardt



"Dennis" wrote:

I am trying to format text with an input mask like the one used for a SS#.
But what iI need would look like this (***-***-***-**-***). Is there a way to
add this to the "canned" format selection?
Thanks in advance for your help