•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to fix cell formatting with decimals?
Adding picture reference.
If I add the 0 before the # it makes it 0 for even numbers that are higher than 0.99 (or less -0.99)
I only want it to be in the format of $ 0.XX or $ (0.Xx) if its values fall in the ranges of -0.99 to 0.99 and for everything else I’d want to have a whole number only - eg. $1825 even if it’s $1825.23 I want to be able to decrease decimals manually or maybe just through the formatting.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#cell formatting
#decimals
#0.XX
#(0.Xx)
#-0.99 to 0.99
#picture reference
#whole number
#$1825
#$1825.23
#manual formatting
#decrease decimals
#even numbers
#higher than 0.99