Dear all,
I have looked for a solution on this and I can't seem to find one. My request is fairly simple but I am new to VBA programming and can't quite get my head around it.
Basically I want to have a VBA code (cell or worksheet change event?) that operates in one column in a sheet e.g. C2:C1000 and keeps the number of characters that are entered in that cell to three, prefixing any value less than 3 characters with zero's. There will never be reason more than 3 numbers will be entered into this column.

It doesn't matter to me (I dont think) if the resultant is a text string or numbers.

For example.
If I enter "3" into C2 I would like it to automatically change to "003"
If I enter "32" into C2 I would like it to automatically change to "032"
If "321" is entered I would like it to stay as "321"
And then the same throughout the whole column down say 1000 rows or so.

I could do it with formulas in a different cell but I want to keep the sheet streamlined.

If it is possible I would be really appreciative of the help!

Thanks in advance!