How do you put in a double zero in excel?

Answer 1

Format the cell to display the number as text. (format - cells - "numbers" tab - select "text") If you still want the value to display with a right-hand alignment you will need to change that option, as it is not the default for text entries.

Answer 2

If you mean that you want to put 00 before numbers like this 00876, then you need to put them in as a text format. That can be done by formatting to text or simply by putting a single quote before the values like this:

'00876

To put just 00 in, you would do it in the same way:

'00