Forum Discussion
How to change a date format back to a decimal in excel?
I opened an old excel spreadsheet populated with many data entries that were originally in a decimal format with 1 decimal place e.g 4.5 but I found that they have all been converted to a d-mmm date...
Hello,
If I get your question accurately, you want to change date from decimal to proper date format. If that's what you meant, kindly execute CTRL + 1 on the date column of your data.
In the Format Cell dialogue box, you can select desired date format
If I get your question accurately, you want to change date from decimal to proper date format. If that's what you meant, kindly execute CTRL + 1 on the date column of your data.
In the Format Cell dialogue box, you can select desired date format
Hi, Abiola1
I don't think Tony_Curn had this in mind.It's that somebody sends you an excel file, let's say with mater data. On original computer, the data is in decimal values.
I receive it via email. I open it on my computer. And certain decimal values are ''automatically'' changed to arbitrary dates. Now, if I format it back to numbers, the numbers are not the same anymore.
e.g: 1.5 ---> May first (or June 5th, depends on the will of excel at that time), and then convert back to number, you get something like 412381.
1.5 =! 412381
That's the problem here.
