Hi, I tried formatting it to general and it stays the same. So I think it's entered in as text.is it a format issue ? or is it entered as text
format the cell to general and see if you just get a number
then use format
mm/dd/yyyy h:mm:ss
Book3.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | G | ||||||||
12 | 2/24/2022 10:02:11 AM | ||||||||
13 | 2/24/2022 10:02:11 | <format as m/d/yyyy h:mm:ss | |||||||
14 | or however you want | ||||||||
Sheet1032 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A13 | A13 | =A12+0 |
Thank you!Also try:
Select your Text date cell
Click on "Data" Tab, Click "Text to Columns"
Click "Finish"
It should change your Text date to Real Date, then format to display as you like.