I'm creating a receipt form that's simple enough for non-Excel expert to use.

There's a column where you enter stuff called BSB number (Bank-State-Branch)
and it is two sets of three digits with hyphen in between (ex. 062-913)

I'd like to format cell so that you type in six digits (ex. 062913) and have
it displayed as 062-913. I'd also like to restrict the entry to six digits
exactly.

With Excel 2007, in Format CellsNumber, I chose Custom and specified Type:
###-###. Also with Data Validation, I put Allow: Text length, Data: equal
to, Length: 6.

This, however doesn't seem to work and when I enter the above example, error
message shows and if you press on, it'll show as "62-913".

How can I make this to work?
--
Maki @ Canberra.AU