FileSaveAs Site
Welcome, Guest. Please Login or Register
 
FileSaveAs Main Site FileSaveAs UK News Feed FileSaveAs Newsletter Follow RFileSaveAs on Twitter FrequencyCast Podcast FrequencyCast on iTunes
  HomeHelpSearchLoginRegister  
 
Page Index Toggle Pages: 1
Change date from 3mx to 5mx type (Read 1379 times)
dazzledoc
Newbie
*
Offline


Visitor to www.filesaveas.
com

Posts: 11
Gender: male
Change date from 3mx to 5mx type
May 28th, 2009 at 1:59pm
 
I have just got a 5mx and have transferred my files from a 3mx. In the spreadsheet the 3mx date "=date(108,12,31)" does not display. I note that any dates from 1999 or before do display. Is there some way I can convert the post 2000 dates to a format that the 5mx will display? Thank you.
Phil
Back to top
 
 
IP Logged
 
Damian Walker
Full Member
***
Offline


Psion enthusiast

Posts: 90
Kingston upon Hull
Gender: male
Re: Change date from 3mx to 5mx type
Reply #1 - Jun 1st, 2009 at 8:01pm
 
Did you convert via another format like Excel?  If so, and it hasn't worked, then I think you may have to change the dates manually.  The 5mx will let you enter today's date as 1/6/2009.
Back to top
 
WWW  
IP Logged
 
Page Index Toggle Pages: 1