You won't be able to do what you want. Numbers can only be 15 digits long.
No exceptions. I believe you will have to enter the account number as text
and include the dashes. If you had a shorter account number you might be
able to do it, but it would fill in the left with zeros, not the right.

"iggy10284" wrote:


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