I need users to input a four digit number between 0001 and 9999 in cells in
column "B".
Rather than forcing the user to enter leading zeros, is there a way, either
using code or formula, to automate the process meaning the user can input
"55" for instance, and Excel will automatically add the two leading zeros?
I have also set up a 'Custom' number type (format cells) which will place
"09/" in front of each entry in column "B". This would need to be taken into
account.
Example - 09/0055

Thanks,
--
Traa Dy Liooar

Jock