maninweb
New member
- Joined
- Mar 22, 2011
- Messages
- 88
- Reaction score
- 0
- Points
- 0
- Location
- Germany
- Website
- excel-translator.de
- Excel Version(s)
- 2010, 2016, 2016 Insider
Hi there...
my friend Andreas and me were involved, IMHO, in an interesting discussion on LinkedIn about the behaviour of Excel when using the TEXT() function to retrieve the months of a given time/date.
With German Windows regional settings, I am able to retrieve the minutes by using TEXT(NOW(), "mm") and the month by using TEXT(NOW(), "MM"). In this case, Excel differenciates between lower and upper cases of the letter M. If I change the Windows system regional settings to English (US or UK), both TEXT(NOW(), "mm") and TEXT(NOW(), "MM") return the month.
So my question is, am I right, if I say that it is not possible to retrieve the minutes by only using the TEXT() function with non-german regional settings? (without appending or prepending other format strings like hh) Or did I oversee something?
Thanks & Best Regards
my friend Andreas and me were involved, IMHO, in an interesting discussion on LinkedIn about the behaviour of Excel when using the TEXT() function to retrieve the months of a given time/date.
With German Windows regional settings, I am able to retrieve the minutes by using TEXT(NOW(), "mm") and the month by using TEXT(NOW(), "MM"). In this case, Excel differenciates between lower and upper cases of the letter M. If I change the Windows system regional settings to English (US or UK), both TEXT(NOW(), "mm") and TEXT(NOW(), "MM") return the month.
So my question is, am I right, if I say that it is not possible to retrieve the minutes by only using the TEXT() function with non-german regional settings? (without appending or prepending other format strings like hh) Or did I oversee something?
Thanks & Best Regards