currency format Excel 360
I highlight a column and click on the format for "currency" and choose options for use 2 decimal places, show dollar sign, then for negative number, no minus sign, no red. Aside from the currency format tab, I choose to format the column in red and bolded using the "home" button. The problem is this format is inconsistently applied. Sometimes it shows a leading minus sign, sometimes it shows a hidden minus sign, and sometimes there is no minus sign at all. This causes me problems when I try to total a column by highlighting it and looking on the lower right for the value. Why is it doing this and how can i stop it?
Excel command icon to change from upper or lower case text
Where is the command icon for changing text from upper or lower case. There is one in word, but none in excel that I can find. I though this would have been a standard feature. After the 40 years of development. Also you can not use, format painter to change the text to upper case either. Please add this feature for the 41st anniversary
Excel Help
Is there a way (either formula or macro /something) for the following. I have 2 different spread sheets (files) open at the same time. First is called Time Card Second is called Wages Time Card will have a staff members details as well as dates and shift times. (20 Tabs for different staff members and their details) Wages will have Tab 1 - Summary of all staff names, hourly rates, hours worked for each day and gross amounts to be paid Tab 2 - 20 payslips with the above mentioned details, but payslip style. Lets call the first person Joe Deer I need something in Time Card next or close, to this person's name, when clicking it it will jump to his payslip in Wages sheet As mentioned. Formula or macro.. Guess anything will do. Thanks
sum function with text
total noob here... after a quick search, i didn't find anything on this... i want to do a sum formula, but i also want to add text to the cell after the sum is completed. is there a way to add this to the formula? do i just do the sum formula, then go back and add the text to the box or will that throw an error? do i just add the text to the cell next to the formula? thanks in advance!
Pivot Table
Hi everyone, I have an issue with the pivot table. There are filters from slicers and row labels in the table; when I double-click on any category from the table to see the filtered data, Excel fetches all data, not just what I filter on. Like below, I filtered from the slicer, and from the row labels, (Bills) should be between 100,000 and 200,000. I would like to see the (Bills) for (Central) in the (Start), but it gives me 632,478 and bills less than 100,000 and 200,000, not the 3 clients. Even if I tried from (In Progress), it's the same; it brings all data. The issue is only with the Bills column, but other filters come up correctlySorting dataentries but keeping separation between subheadings
Hello! I would like to sort datasets with three columns, but keep the sets separate with different subheadings, but sort them all within themselves. I find it difficult to explain further with words but will attach images. In the first images the datasets are shown as entered and by default are sorted by the leftmost column, as that's how they're entered. I would however like to be able to sort by the right most column, but keep all the datasets separate. I have made a mockup in the second picture to show what I mean. Is this possible? Thank you in advance!
