Resolved: Custom cell formatting not working
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
Thank you Ned!
Thank you Ned!