-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
regional dates
-
D
Date formatting interferes with formulas
Hi! I created an Excel tool that utilizes basic DATE to TEXT formula to get a certain output format:TEXT(TODAY(),"yyyymmdd") I had to hand the tool over, but it doesn't work in the other PC anymore (some bogus output). Both are Win10 + Office365. Main difference - while my PC regional settings...- dotsent
- Thread
- date regional dates
- Replies: 4
- Forum: Excel Questions
-
L
Insert date in format different than one in regional settings
Hello! Apologizes if that's answered somewhere, but I failed to find straight information on that. Issue: We've got excel spreadsheet that's being shared between different people using different regional settings, but we all update it with same parsed data, having one strict date format...- Leferty
- Thread
- date excel format regional dates
- Replies: 3
- Forum: Excel Questions
-
K
Regional/International Date Issues!! mm/dd/yyy vs. dd/mm/yyyy
Hey all - this one has been driving me nuts, and I'm sure there's an easy fix to it but I'm not sure what it is - I've set my date tables up per the first table below, but when I link the data table, PowerPivot recognizes the date in a different format. The Excel date table is in the same...- KyleHansen
- Thread
- date table international dates regional dates
- Replies: 3
- Forum: Power Tools
