how can i get Mac Numbers to display date instead of serial number?'
how can i get Mac Numbers to display date instead of serial number?'
MacBook Air
Apple Event: May 7th at 7 am PT
how can i get Mac Numbers to display date instead of serial number?'
MacBook Air
Hi Ozzy,
Have you imported the document from another app (such as Excel?)
A screen shot of your Numbers table (or copy the relevant part of the table and paste into a reply) will help us to help you.
Regards,
Ian.
The spread sheet was created on Open Office software and save on a flash drive as (.xls) and the transferred to my Mac book Air. The dates show up like this instead of the normal date format. Not sure if I can do something to switch them back or if I need to save the spreadsheet in a different format.
Thanks for any help.
Second thought. The document was created in Excel. Excel may have used 1900 as the base date.
how can i get Mac Numbers to display date instead of serial number?'