Cell date as custom date format

[ipbr21054]

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

 

[etaf]

if it is a real date and note text
to check, change the format to general and you should see a number

if a number
then
format - custom - and type in
DD-MM-YYYY

and will format as you want

I'm a little concerned its strange that DDMMMMYY did not show as
07march23

hopefully the different formats will show in xl2bb

Book1
	A	B	C	D
1	normal default	number	ddmmmmyy	with dash
2	3/7/23	44992	07March23	07-03-23
Sheet1

 

[ipbr21054]

For the cell in question should i be doing this.

=TODAY()

Then format that cell as custom & type in DD-MM-YYYY

 

[etaf]

if you want to
or type in a date

so long as it changes to a number when format as general - then its a real date

i have change the row 2 to use today(), and change the dd-mm-yy to dd-mm-yyyy as you asked to show 2023 not just 23

Book1
	A	B	C	D
1	normal default	number	ddmmmmyy	with dash
2	3/7/23	44992	07March23	07-03-2023
Sheet1

Cell Formulas
Range	Formula
A2:D2	A2	=TODAY()