ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,235
- Office Version
- 2007
- Platform
- Windows
Hi,
I am trying to get the date in cell R14 like this 07-03-2023
Looking in the properties format date & custom options i dont see this.#
I can see 07\03\2023 but i am then unable to save worksheet because of the \\\
I also see DDMMMMYY but that then displays 07-Mar-2023
Is there a VBA way to display like so 07-03-2023
Thanks
I am trying to get the date in cell R14 like this 07-03-2023
Looking in the properties format date & custom options i dont see this.#
I can see 07\03\2023 but i am then unable to save worksheet because of the \\\
I also see DDMMMMYY but that then displays 07-Mar-2023
Is there a VBA way to display like so 07-03-2023
Thanks