•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Need to be able to use dashes or 0s in cells; getting error from excel
Our take
If you're encountering issues with entering both 0% and dashes in your Excel spreadsheet, you're not alone. Many users face the "don't leave this cell empty" error when trying to input a dash, which can be frustrating. This often stems from specific cell formatting or validation rules set in the pre-made spreadsheet. To resolve this, you can explore custom number formats or adjust the validation settings. Let’s delve into how you can empower your data entry process and regain control over your spreadsheet experience.
I have a spreadsheet I'm working on where I need to be able to enter 0% as a value sometimes, and other times I need to be able to enter a dash as a way to indicated n/a. I can't figure out how to even enter a dash without getting a "don't leave cell empty, enter a 0" warning from excel. Is there a way to format this that will let me do either? I've tried playing with conditional formatting and custom cell formats but can't figure it out.
Also does anyone know where that "don't leave this cell empty" error might be coming from? It will let me do zeroes and dashes in other cells, but this spreadsheet was given to me pre-made and I think they must have changed some setting on these cells that I don't know how to undo. Tried googling and got frustrated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Font formatting of a calculation dashboard KEEPS reverting every time the data in the other sheets is updatedI am at my wits end, every time I open this spreadsheet the formatting of these cells (supposed to be large and extremely readable to low-tech users on same team) reverts back to Calibri size 11 for some reason. I even created a custom cell style to try and force it to stay that way and I can see that it's selected in the menu, but not reflected whatsoever. Is it just impossible to format cells with a constantly changing calculation? What can I do here?? I feel like I have gone through every formatting constraint/rule there is to try and force it to behave but it always changes back, even if its not right away. It's a spreadsheet stored on sharepoint primarily but I don't know if that makes a difference. Advice appreciated. 😞 submitted by /u/vailette [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]