Thread: format social security number as XXX-XX-1234
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
svetlana svetlana is offline
external usenet poster
  
Posts: 2
Default format social security number as XXX-XX-1234
Does someone know how to format a social security number
as XXX-XX-1234? I know how to do this using concatenate
function, but would like to find out if it is possible
using the formatting programming. I tried:
_("XXX-XX-"0_) and _("XXX-XX-"#_), but that i still get
the whole number after the X's.
Thanks!
Svetlana
Reply With QuoteReply With Quote