Hi all,
I am working with pivot tables, and the imported data always comes in as dd.mm.yyyy is there a way to create a macro that formats specific columns from dd.mm.yyyy to mm/dd/yyyy?f
Hi Team,
I really hope you can help me to fix my problem.
I have a huge(over 1000 rows) xls-sheet report containing a column "T" having date information (i call it information because the column is formatted as "general") in the US format MM/DD/YY. In order to use the date information, I need...
Hey.
I've run into a problem: I've been supplied with dates, of which I need to remove anything that is 4 weeks or more from today's date. Now the problem is that the dates I've been supplied with are in the format (dd.mm.yyyy), while excel gives today as (mm/dd/yyyy).
How can I get around the...
Good Morning,
I'm facing an annoying issue, in my data sheet dates are formatted dd.mm.yyyy and when I create my pivot, data are read mm.dd.yyyy which makes the automatic grouping by month totally wrong.
I have checked my regional settings and everything is in dd.mm.yyyy.
Any idea where to...
Hi there,
I have a VLOOKUP formula that pulls through a date (dd/mm/yyyy) but the format converts the appearance to dd.mm.yyyy.
I notice that when i copy and paste values, the dd.mm.yyyy value is present, but it remains as dd/mm/yyyy in the formula bar!
How do i keep this as dd.mm.yyyy? I...
Hi,
I have the following table:
In column "A" : dates (dd.mm.yyyy)
In column "E": times (hh:mm)
I'd like to have the followings:
18:00 <= Times < 22:00
How many unique days match that criteria?
Thx in advance
Hi!
Can anyone please help me write a shorter vba code?
This vba code I need for editing futsal players records.
That vba code works well, but it's too long.
The code below is short example because its too long. But I have in league 10 teams, so I would like a better solution.
Thank you in...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.