formatting cells

  • Thread starter Thread starter david
  • Start date Start date
D

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?
 
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.
 
Back
Top