G Guest Mar 10, 2004 #1 Is there a formula i can use so that a cell will only accept numbers, But will keep leading zero's
F Frank Kabel Mar 10, 2004 #2 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)
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)
