Forum Discussion
Tony_Curn
Nov 03, 2019Copper Contributor
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...
Riny_van_Eekelen
Nov 03, 2019Platinum Contributor
I'm on a Mac and when I choose to format a date I can select the region "Alsatian (France)". It will show the decimal format as one of the standard options. If you don't have these you might try a custom format "d.m;@". I've attached some screen shots that show you what I mean.