If you entered a date or time as a string of numbers separated by hyphens, 10-31-91 for example, NExS would interpret this string as a formula and display the result in the cell as -112.
To tell NExS to interpret the entry as a date or time, begin the entry by typing a slash (/) before the desired value. Type a / followed by the date or time in the formats mm/dd/yy, dd.mm.yy, dd-mmm-yy, yyyy-mm-dd, and hh:mm:ss. The dates and times entered with this method are converted to the equivalent references to @DATE and @TIME. For example:
Date/Time | Entered as: | Generates: |
19 July 1990 | /07/19/1990 | =@DATE(90,7,19) |
6 April 1966 | /6.4.66 | =@DATE(66,4,6) |
27 September | /27-sep-91 | =@DATE(91,9,27) |
24 March 1954 | /1954-3-24 | =@DATE(54,3,24) |
12:30 | /12:30 | =@TIME(12,30,0) |