I am trying to create a custom format for my account numbers. An example
of one of the account numbers is 9500-01-010-02-010-000-00. I want to be
able to enter just numbers and have the dashes be put in automatically,
but here is the kicker.... I also need it to fill spots with zero if no
data is entered. So if I enter 9500 it will appear as
9500-00-000-00-000-000-00. Any help would be greatly appreciated.


--
iggy10284
------------------------------------------------------------------------
iggy10284's Profile: http://www.excelforum.com/member.php...o&userid=32078
View this thread: http://www.excelforum.com/showthread...hreadid=518291