formatting cells

[david]

Hi

I'm trying to enter numbers in cells in the form 123-456.
Is there a way to stop me accidently entering numbers
such as 123-4567?

I also want the zeros to show, for example 001-001, not
1-001. Can anyone help?

 

[Roger Govier]

Hi David

Mark the range of cells required then
Format=>Custom=> and in the white pane enter 000-000

Then with the range of cells marked, choose
Data=>Validation=>and from the first drop down choose Custom
In the formula pane enter =LEN(cellref)=6
where cellref is the address of the first cell in your range.