ExcelBanter - How do I change date that is in All Caps to proper format?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I change date that is in All Caps to proper format? (https://www.excelbanter.com/excel-worksheet-functions/254141-how-do-i-change-date-all-caps-proper-format.html)

jsintay1231

How do I change date that is in All Caps to proper format?

David Biddulph[_2_]

How do I change date that is in All Caps to proper format?

=PROPER(A1)

and next time, please remember to ask the question here in the body of the
message, not in the subject line.
--
David Biddulph

"jsintay1231" wrote in message
...

All times are GMT +1. The time now is 04:29 PM.