You can add a zero before a number in Google Sheets and Excel using this tutorial. You need to change cell formatting or use function.

In a previous tip I showed you how to create numbers with leading zeros by typing either an apostrophe in front of the leading zero or a space somewhere in the number. But what if you require the ...

How to Get Chart Bars to Show Red When the Value Is Less Than Zero in Excel?. When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same ...

The example tells Excel to look in column "B" for each row and determine if the values are less than zero. If a value is less than zero, the conditional formatting is applied to that row.

In the Maximum iterations box, type the number of times you want Excel to recalculate. The higher the number of iterations, the more time Excel needs to calculate the worksheet.