showing

I never use Excel to create graphs/charts. I was asked to do one today and I'm having an issue. the data is weekly but the horizontal access should be monthly. It's showing the weeks which of course makes it look terrible. In fact the dates don't line up with the data. Help!

So, I'm using custom formatting to show -$1,200,000 as -$1.2M, but Excel is showing it as -$1200K. Here's the custom formatting that I'm using: [<999950]$0,"K";[<999950000]$0.0,,"M";$0.0,,,"B" The weird thing is that when I do a positive number, like $1,300,000, it shows up as $1.3M, which is...

Hi. I am trying to convert 9.10 to 9 years 10 months but the result is showing 9 years 1 month. Please help me.

My spreadsheet is showing formulas in some of the cells. I type in a formula and it appears as though it was text even though it starts with=. Also the format of the cell is "General." Actually, there are 600 cells showing the formulas. But while I kept messing with the cells one or two of them...

I know when you do a Vlookup on a date , say 4/16/1, it's going to pull the first one it finds and nothing else. Suppose I have any number of lines showing a specific date, is there a way I can pull the sequential info from the cells in that column?

Hello all! Trying to generate an automated email with Gmail that includes a screenshot of a previously generated image but it's only showing the alternate text as defined in .HTMLbody. I've confirmed the HTML code works in a localized file but it's not showing in the email. Any help would be...

Can someone help me correct the following formula. =COUNTIF(J2,"*") This correctly allows for the number 1 to appear in C2 when J2 has any text, however if J2 is blank, I want C2 also to be blank rather than showing 0. I am aware I can set Excel not to display the value 0, but this is not...

Hello, I'm using this formula below so I don't count duplicates, however, I would like to add to this if possible.... if a number is showing in column B and Column C and a date is showing in column D then count how many times. Is there a way around this? I do need to count the duplicated in...

What's wrong with this formula? In row A1:A10 if i write t it gives =NOW but not the FORMULA for showing time. What is the mistake here? Thanks!

Good Day, How can I populate the datas into the listbox base on selected two comboxes. ComboBox1 datas located on column A "showing as months" ComboBox2 datas located on column B "showing as department names" Many Thanks

I have created a pivot table based on a data table. However, in the pivot table fields, one of my columns from the raw data table is not showing up as a selection. I have tried to search for it in the choose field to add to report and it is not showing up at all. I have even tried to create a...

HI, My week name (like Week 1, Week 2, Week 3...) in slicer not showing in the right order, I tried to sort Week by Date in the calendar table Error showing that 'at least one value in Week have multiple distinct value in Date'. How to sort in proper order. One more issue : some weeks are...

(Like many of you) I've been given a task to update an externally-created spaghetti-link spreadsheet. In this case it is a pro-forma to estimate the cost-per-pound of linen going through a proposed laundry. In essence it is a series of matrices through which the linen volume moves. First is a...

Hey guys, I am tired of this situation, each and every time I close any sheet it is always showing these prompts and also when I open it is showing the Document Recovery Pane on the left, how can I solve those two issues please? https://s10.postimg.org/bvlf3yy5l/Screenshot_2.png

Hi All, I am having trouble with a formula and my excel formula knowledge is fairly basic. I have the below formula that i have come up with =IF(K7=0,"",(L6+K7)) however as the reference cell K7 also has a formula it is not picking this up as blank and showing a #VALUE ! error. Can anyone...

Hello Excel Experts I'm trying to set up some drop-down menus, with the first one determining what will show in the second one. The first one (and I'll use the actual cells in my sheet so I don't get confused), located in cell E15 will show a range of numbers from 1 to 10 - defaulting to 1. The...

<tbody> A B C D E F G H I 1 1234 111 2 1235 112 3 1236 113 4 1237 114 5 1238 115 6 1239 116 7 12310 11-3 8 9 </tbody> Good morning/afternoon I am running a simple test in excel and I was hoping to get some...

I have created a sheet with a lot of data that will be input over time, and there are ##### showing up that I would prefer not be there. Is there a way to, easily go back and make those go away? thanks, and just for information there may be more than 200 cells in the sheet showing this. this...

I have a simple chart showing calls by day average. Year 1990=100 1995=200 2010=400 2014=515 I want to create a simple line graph and add a trendline showing what calls might be in 2025. Help please. I think I'm over thinking this!

If I have a column of numbers (money amounts) is it possible that I could get a sum of all the paper bills and all the coins? For example: 12.75 22.50 56.10 Can I have two separate cells with one showing me the paper bills I have collected along with the actual amount of coins? Bills 90.00...