Sylvia has attended:
No courses
Formating.
How do i format A1in a column to become A01.
what i normally do is add the 0 manually.
RE: 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