Hello, this is my first time posting. I have never been "formally" tought how to use Excel, except a beginner course, and have virtually NO experience in VBA. From reading this forum, I have gotten some basics though. I have mastered the basics of Excel by the process of "trial by fire" and found myself stuck.
I was assigned a project here at work where I had to create (from scratch) and maintain a system to track a process. I have my main workbook that is 3000 rows and that grows by about 100 each week. I had a column ( 1 of 29) that began as a text column, but I was given directive to create a column that would keep track of wheter a document was sent to a certain office or not. I have been doing this by simply using a numeric column, and in the row that needed it, I entered "1". Then, at the bottom of that column I have a cell that has the basic formula to add all the cells in that column together. This has worked in 14 other columns. This one however does not want to run the formula, I have to go back and retype each "1" to get it to add (my formula being =sum(d2:d2988) ). This would be fine, but when ever I add the new rows for the week, I have to reformat and retype each and every cell in that column.
Any advice on why Excel is not accepting the change from text to number? I have already tried making sure the page/column/cell is not protected, I have even tried deleting and recreating that column, but nothing seems to work. Any help would be appreciated. Thank you.
Also, this one may have been asked before, but I was not able to find it in the first 10 pages of threads, I have a sheet that takes the number from my monthly stats and combines them onto one sheet for monthly/quarterly/yearly. It looks very confusing with all the "0" from the cells that are yet to be filled in by data due to it not being that month yet. How do I make a cell show blank instead of the "0" when a formula is already entered there?