•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Cell Format for numbers HELP :)... getting rid of a useless decimal point
Our take
If you're looking to refine your number formatting in spreadsheets, you're not alone. Many users want to display decimals only when necessary and prefer a clear representation of negative values in red. Your current format is close, but it still shows a decimal point for whole numbers. To achieve your desired outcome—showing commas, displaying negatives as red, and eliminating unnecessary decimal points—consider adjusting your formatting string. Let’s explore solutions that can help you achieve the clean, precise look you’re aiming for in your data presentation.
I know I'm being incredibly picky here & I've ALMOST got it! I want my numbers to:
- show decimals ONLY if necessary
- show negatives as (red)
- include commas
- - instead of 0
#,###.##;[Red](#,###.##);-
The above is doing ALMOST what I want but it's still showing the decimal point if it's a round number.
Anyone solved for this? THANKS!!!!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Negatives in Red in a "Format as Table"I have a document that I have used "Format as Table" so each row is a different color. I want to make it so that when a number is negative, it turns red. I thought I was able to do that with conditional formatting, but I just now realized it makes the background of all the cells white, even those in the row that is colored. Any way to fix this? I already tried formatting the cells using the number format "0.00%;[Red]-0.00%", but still having the same issue. Any ideas on how to get this to work the way I want it to? I really want don't want to have to manually format as a table (different color every other row). Pic to help show what the issue is. https://preview.redd.it/wje9ghguo7zg1.png?width=1928&format=png&auto=webp&s=3f6510812414388e511f564aa676d4744152272e submitted by /u/Significant_Floor_54 [link] [comments]
- How to hide zeros in a table but keep relevant decimals?I am having a hard time figuring out the custom text in cell formatting to hide zeros. What I want to hide: 0 0.00 With just Div/0 error corrected When I use this custom formula 0;-0;;@ in the custom text formatting it deletes all of my decimals in my table. Using 0;-0;;@ custom formatting, which removes all zeros, including decimals Basically, I am trying to have my table show nothing if all the data is zero (because there is no data yet) while still maintaining the formulas. I have removed the Div/0 error, but I cannot figure out the custom text needed to get rid of the zeros while still keeping my decimals. I would love to avoid conditional formatting if at all possible. I saw some people just change the text to white. That won't work for me because I use different colors in my Excel workbook. Is there a custom text I can use to achieve what I am trying to do? submitted by /u/MinorFX [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#Excel alternatives#cell format#decimal point#number formatting#Excel#negative number#custom format#comma#round number#formatting string#display rules#number display#financial formatting#hundreds separator#color coding