Formating.

Hi Sylvia

Thank you for your question. In this case you could right click the cell in question, choose Format cells then from the number categories choose Custom.

In the Type entry cell replace the contents with A00 (A zero zero)
Now when you type a single digit in the cell Excel will add A0 before your entry.

You can then use format painter to copy the format to other cells.

Let me know if this produces the result you are looking for.

Kind regards,

Andrew