LinkBack URL
About LinkBacks
Hi Everyone,
I have a formula that give the date of payment. ("L19 to L22").
I would like to update the formula for the result (month) come with capital initial.
Thanks for your help.
Regards,
Hi Everyone,
I have a formula that give the date of payment. ("L19 to L22").
I would like to update the formula for the result (month) come with capital initial.
Thanks for your help.
Regards,
So 06 January 2023 would look like 06 J 2023.... or what??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I would like appears 6 of January of 2022
Please format your cell: custom format: d of mmmm of yyyy (or if your local setting is Portuese: custom format: d of mmmm of aaaa)
I Try what you tell me but don't go. Can you please give me a example in the sheet I send ???
Custom date formatting applied as suggested in post #4 in the attached.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
thanks but is not what i need .
What I would Like is the cell in sheet (that have already a formula) give me "6 de Janeiro de 2022" instead of "6 de janeiro de 2022"
This is what I see, in your ORIGINAL sheet:
1. Is this what you want?
2. What do you see?
Yes Is that what I want !
I have in the first line "06 january 2022" and I want as you send me "06 January 2022" . How can I change it ??
I did NOTHING. That is exactly what I see immediately afer orpening your file.
What locale is that cell range set to??
I send you again the file.
thanks
It's the same. I see it capitalised. When YOU open it, what locale is set for those cells?
I think the problem is to combine in the same formula and cell the 2 formulas that i Have:
1: =SE.ERRO(SE(J35=0;"";DIA(J35)&" de " & INICIAL.MAIÚSCULA(TEXTO(J35;"mmmm"))&" de " & ANO(J35));"") and......
2: =SE.ERRO(MENOR($J$35:$J$74;CONTAR.SE($J$35:$J$74;"<="&MÁXIMO($L$18:$L18))+1); "")
I asked you a question. What is the answer?
The sheet I send you in attchament is 1 of maybe 10 sheets in the same file.
I understand that the sheet I send you read information from another sheet of the file.
I supose maybe wrong, for give a solution for my problem is not necessary send you the entire file with all the personal information.
My local setting is dutch and I see 6 januari 2022.
I can not easy change the j in a J because in dutch you write januari with a j and not with a J.
You can easy choose for an other language and you get a capital if a capital needs in that language.
If I chooce Portuguese [Portugal] I get 6 de janeiro de 2022, because conform Excels Portuguese date settings you have to wirite the month in a date not with a capital in Portuguese.
Is this Excel's Portuguese translation of the month in a date without a capital not right?
Last edited by HansDouwe; 12-04-2022 at 03:42 PM.
You still don't have the first letter of the month in capitals.
Indeed, but I wonder why you would want to, because according to the Excel translators you should not capitalize the month in a date in Portuguese.
That's why I asked you, do the Excel translators get that wrong?
Also according to google translate you should not capitalize the month in a date in Portuguese.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks