Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formating.
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Formating.
Resolved · Urgent Priority · Version 2003
Reply Tue 20 Jul 2010, 12:00Delegate Sylvia said...
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.
For upcoming training course dates see: Pricing & availability
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
|