How can I tell Excel to not display values between -.001 and +.001? I prefer not to use white font, because I have conditional formatting that changes the fill color, and the white font shows.
Is there anything equivalent to 0;-0;;@ ?
How can I tell Excel to not display values between -.001 and +.001? I prefer not to use white font, because I have conditional formatting that changes the fill color, and the white font shows.
Is there anything equivalent to 0;-0;;@ ?
Try [>=0.001]General;[<=-0.001]-General;;@
Entia non sunt multiplicanda sine necessitate
That did it--perfect!
Thanks for responding.
You’re welcome. Would you please mark the thread as Solved?
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
Funny...for me I had to change it to this format to work:
doesn't the @ at the end make the cell a text value? It did for me
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks