how to insert subtotals in excel for mac

Insert Subtotals In Excel How To Do That

Upto a 100 cells that was doable (upto 20 possibly quicker) but I often have upto a 1000 cells (which definately causes RSI). Thank you.

Insert Subtotals In Excel How To Do That

Theres a video at the end of this article, that shows how to do that.

You could go to each cell, and remove the apostrophe, but that could take quite a while, if you have more than a few dates to fix.

In this example, the dates show monthdayyear, so Ive selected MDY.

There are details on the Fix Numbers that Dont Add Up page on my Contextures site.

Thanks for the reminder, and Ive added that to the article, with a link to my page on fixing text numbers.

I feel like Ive wasted too much time reading other more complicated ways of performing this simple fix.

Finally QBO suggested that I use DATEVALUE, copy and paste that column as values, then reformat the values to date format.

Now the dates will not format to the existing data in the old USA date format, 042514.

Before I could type 4-25-14 and the program automatically changed it to 042514.

Now one of two things happens: it stays as 4-25-14 (left justified like text) or formats to 25042014.

I have used the numberdate format on the column and the cell to no avail.

Since we are in Costa Rica, it seems on some cells the program is reading the ISP address and formatting to the International style, but this does not happen in most cases.

When it does, the only solution it seems is to convert it to text by placing an apostrophe in front of the number.

This is yet another totally aggravating and frustrating MS problem.

If you change the regional configuration the dates must be showed as the region or country you select.

If that doesnt work, or you dont want to change the configuration in your machine, select the whole column where your data is then right click, select format cells and in Category select Custom and then in the Type field write: mdyyyy or the order you need.

Ok. From there you can place the dates in any way you want, just check how the formats must be declared from that window.

To explain, I made the mistake of formatting my field as date (using the 000000 format), but making it left-aligned.

When I entered 4-04-2014, it would show up as 4-04-2014 instead of 04-04-14 as it should have.

But other times, I would still get 4-04-2014; then I would change one numberof the date -- either I could delete the 0 in the 04, or just delete a digit, then re-enter it (like deleting the 4 in 2014 and then retyping it.

When I did this and exited the field, it automatically right-justified the date and showed it in the desired format: 040414.

I discovered--quite by accident--that if I clicked in the formula bar of a given cell, the formatting change appeared.

Is it just me, Sue, or do we, the paying customers, end up doing MSs beta-testing for them:(.

Followed your guidance and as a result I got the same 5dyyyy h:00:00 AM in each cell.

Upto a 100 cells that was doable (upto 20 possibly quicker) but I often have upto a 1000 cells (which definately causes RSI).

How To Insert Subtotals In Excel For Mac