Formatting of Numbers seems unavailable in certain cells

[RobVos]

I have a sheet which has the same formula in a row of cells. I have them all se t to currency formatting, however only some of the cells are displayed as currency. I tried to copy formats to the cells not displaying proper, but nothing changes. I checked the format and I noticed that all the specific formats are not displaying proper for those cells - they are all just a plain number (depicted as a zero in the dropdown). The two images below show the difference for the cells. Both are set to currency. Anyone know how to fix this?

 

[arthurbr]

Could it be that for some reason those are not real numbers but text looking like numbers? To check remove manual alignment from the column ( they are manually centered). If content of cells is left-aligned they are text, even when formatted as currency ( formatting does not affect the underlying value).
If so, select those cells, Data-Text to columns- Finish. If they are now right-aligned you are ok. If not some further investigation is required

 

[Alex Blakenburg]

You are not showing us the whole fomula try changing the "0" to just 0 without the quotes.

 

[RobVos]

You are not showing us the whole fomula try changing the "0" to just 0 without the quotes.

View attachment 105224

Thanks - I just found that a little while ago and see you noticed it as well. The quotes there are the issue because that formula has an IFERROR that would result in that zero if a match can't be found.
For info the entire formula (corrected) is:
=IF(E4<>"",IFERROR(IF(AND($B$6=2,MATCH(E4,'West Coast'!$D$1:$R$1,0)>8),2*@INDEX(Canal,MATCH(@INDEX(Ships,$B$5,1),Ship,0),0),0),0),"-")

 

[Alex Blakenburg]

Thanks for the feedback. Glad we could help.