Cell data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a formula i can use so that a cell will only accept numbers, But will keep leading zero's
 
Hi
not a formula but you may try
- goto 'Data - Validation' and select 'Numbers'
- format this cell with a customer format. e.g. 0000 (this will always
show 4 digits)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leading Zero 11
keeping leading 0's when formatting cells 3
How do I stop Excel from dropping leading zeros? 9
Leading Zero as value not appearance 2
Array formula to Identify Leading Zeros. 2
How can you format cells in a column to display a 50 digit binary 3
time format 1
How do you stop excel removing the leading zeros in a cell? 2

Back
Top