Resolved: Custom cell formatting not working

Hi Charles,
Thanks for reaching out!
In the excel settings used to record the video, a space has been set as a thousand separator. So putting a space in two numbers (# #) will create a space after every 3 numbers (thousand separators). 

In other systems where space does not perform this function, the common thousand separator is a comma (,) or a semicolon (;).
Please try to identify the one to be used in your case. Hint: take a look at the argument separator to be used when creating formulas.

Once you have identified the thousands separator ,you can go ahead and create a custom formatting style that fits the following logic:

1st separator: how positive figures will be displayed
2nd separator: how negative figures will be displayed
3rd separator: how 0s will be displayed
4th separator: how text will be displayed.

From what I can see, you have used the 1st separator only. You haven't added a 2nd,3rd,4th separator to show Excel how to display negative numbers ,0s, text.
Best,
Ned