Custom date cell format capital letters

Question

Hi!&nbsp;I need change the cell format for date, I want the text in capital letters, all of them, only I can chenge the first letter.&nbsp;I used this format: [$-380a]mmmm;@ but for the days of the week doesn't work, even doesn't change the first letter as in month&nbsp;I cant use the formula =MAYUSC() because the cell where is the month and days makes reference a other formulaCould you help me please?&nbsp;

jbf_54 · Answer

Try =UPPER(TEXT(NOW(),"dddd, mmmm dd,yyyy"))

sergeibaklan · Answer

Viics&nbsp;
There is no such custom number format which forces to return month names in uppercase. If within one cell, i.e. without&nbsp;MAYUSC() / UPPERCASE(), that's with VBA programming.&nbsp;

Forum Discussion

Custom date cell format capital letters

2 Replies

Resources