Question: I have a sheet called "Test". Column B shows dynamic API calls, then I use a macro to copy all cells from Column B to Column C every 1 hour in order to store those prices, however sometimes API call fails, so it shows 0. I want to mass replace all cells containing "0" (match exact case) from all columns of sheet "Test" **without changing** Column B (which is the column for the API calls so we don't want to change its formula).
How can I do that?
Thank you!

Answer: 
The correct syntax is:

```
formatter.dateFormat = "yyyy-MM-dd"

```

Lower or upper case matters here.
The issue there is that D uppercased means the day of the year not the day of the month. Note also that Y uppercased is for yearForWeekOfYear.

If you need further reference you can check this

[![enter image description here](https://i.stack.imgur.com/3Yd5m.png)](https://i.stack.imgur.com/3Yd5m.png)