My custom cell formatting does not work, any thoughts on how I may fix this please anyone?

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