Date Formatting

[rockchalk33]

Probably been answered time and time again but I’m on the road and only have my phone to look at stuff with very little time. I apologize if I’m asking a redundant question:

value of cell A1 = 7/30/2021
formatted it to read 2021-07-30

how do I get the actual value of the cell to be a string displaying 2021-07-30?

I have 300 unique dates that I need to do this to.

 

[Toadstool]

Hi Rockchalk33,

You'd need to put a TEXT function in B1 to get it as a string. You can then copy & Paste Values back to A1 if you want.

Book2
	A	B
1	7/30/2021	2021-07-30
2	7/27/2021	2021-07-27
3	7/24/2021	2021-07-24
4	7/21/2021	2021-07-21
5	7/18/2021	2021-07-18
Sheet1

Cell Formulas
Range	Formula
B1:B5	B1	=TEXT(A1,"yyyy-mm-dd")