Number Formatting Excel 2016

[LeilaniMerle]

Greetings,
Please could you let me know how I can change the following in the Properties of Excel without having to do each column manually. I always need to show as follows:

R 0.00 and NOT R -

Grateful for your assistance

 

[mole999]

i would think that is a custom format applied to a column, but i could be wrong from that one example