Formatting

Hi Faye

Thank you for your question and welcome to the forum.

If the first thing you type into a cell is a letter, then it is not necessary to enter a single quotation mark (') at the beginning as Excel will automatically recognise the letter as text.

Use ' before you type in a number, if you want Excel to recognise what you are typing in as text rather than a number. This is particularly useful if you are entering a number with leading zeros.

Amanda