Forum Discussion

Copper Contributor

May 26, 2023

Why my auto-fill is like broken?

I types May 1, 2022, and May 2, 2022, then I auto-fill. The result comes out like this which is very weird. I also notice that I am not able to format the date by clicking right button and use ...

excel

HansVogelaar

MVP

May 26, 2023

BaiPiaoKer

It looks like Excel sees the values as text.

Format F1 as mmmm d, yyyy

Enter 1-May-22 in F1

Then fill down

BaiPiaoKer
Copper Contributor
May 26, 2023
The number changes correctly, but I am still not able to use the format cell to format. After I click OK, nothing happened.
- SergeiBaklan
  Diamond Contributor
  May 27, 2023
  BaiPiaoKer
  
  In addition, you may enter the dates in ISO format like 2023-05-01, it shall be recognizable independently of regional settings.
  
  One more, if you see your "dates" are left aligned that means you have texts which looks like dates. Dates actually are numbers and by default shall be right aligned.
  
  Finally. applying another format to the cell you do not convert text to date/number, you shall to re-enter the value in proper format.
- HansVogelaar
  MVP
  May 26, 2023
  BaiPiaoKer
  
  You entered 1 May 22, but your system date format is in Chinese as far as I can tell, so you should enter the date in a Chinese format.