You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Good morning,
on an excel file I had the data separated by points (examples 30.07.2021 29.07.2021 27.07.2021) with the export in Numbers they became: 44407 44406 44404) who can help me to report them with understandable dates?
Hi RomeoSierra21,
Excel stores dates as the number of days since 1st January 1900. Sometimes, this becomes a glitch when opening an Excel document in Numbers.
Try this:
Formula in C2: DATE(1900,1,1)+B2−2
Fill down.
The -2 is because 1900 was not a Leap Year (and another reason that I forget!)
Regards,
Ian.
Hi RomeoSierra21,
Excel stores dates as the number of days since 1st January 1900. Sometimes, this becomes a glitch when opening an Excel document in Numbers.
Try this:
Formula in C2: DATE(1900,1,1)+B2−2
Fill down.
The -2 is because 1900 was not a Leap Year (and another reason that I forget!)
Regards,
Ian.
thanks Ian, quick and accurate!
The other -1 is because 1/1/1900 is day 1 in Excel, not day 0. "1/0/1900" is day 0.
date conversion from this xlsx format 07.30.2021 to this numbers 44407
