Dates won't format Hi everyone. I have this export where some dates are formated correctly and some are not in the same column. I have tried the obvious: date format, text to columns, =DATEVALUE, and pretty much
Method 3 – Adding Space to Stop Excel from Changing Numbers to Dates STEPS: Select the cell to enter the fraction number. Keep a space before the number. Press Enter. Do this for every cell in the range. By adding a space, Excel won’t change the format. Read More: How to Stop Au...