+ Reply to Thread
Results 1 to 6 of 6

Excel 2010 treats dates differently to excel 2013

  1. #1
    Registered User
    Join Date
    04-07-2015
    Location
    South africa
    MS-Off Ver
    2013
    Posts
    8

    Excel 2010 treats dates differently to excel 2013

    Strange problem I have excel 2010 loaded on an hp laptop with win 7 and excel 2013 loaded on another laptop with win 8.using the same spreadsheet I get a different answer . Specifically the date 1/04/2015 is evaluated to a number using the @ value function in excel 2010 ,But the same calculation ( same spreadsheet) calculates to # value in excel 2013 on the other laptop with win 8 .Help?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Excel 2010 treats dates differently to excel 2013

    Hi High Tower, welcome to the forum

    Hoe gaan dit daar anderkant die groot dam? (SA expat here from PE and Klerksdorp)

    The only thing I can think of that may cause this, is if the device/program settings are not the same, or that the dates are not really dates

    Does this happen in all files that both machines open, or just 1

    Specifically the date 1/04/2015 is evaluated to a number using the @ value function in excel 2010 ,But the same calculation ( same spreadsheet) calculates to # value in excel 2013 on the other laptop
    Not sure what you mean by "using the @ value function"? sounds more like Lotus123?
    is the column width set right on the other 1? try making that column wider?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-07-2015
    Location
    South africa
    MS-Off Ver
    2013
    Posts
    8

    Re: Excel 2010 treats dates differently to excel 2013

    Hi Ford
    Thankyou for assisting .(Would like to continue a communication via email outside this forum on SA etc)
    I mean the value function .
    It applies to all files on both machines.The date 1/04/2015 is not a date but using the value function I get the excel date number in excel 2010, but I get a #value error in excel 2013.


    Hugh
    Ps I am not sure what device program settings apply:
    1I have checked the excell options (advanced) on both machines ..(They are similar except allowing for 2013's extra functions.)
    2.I have checked the date and time settings on both machine (Both set for UTc+2.00)Harare Pretoria.)

    I suspect that it may have something todo with the way excel reads text.(USA date ?) Not sure how to check for this .
    Regards

    Hugh
    Last edited by HughTower; 04-08-2015 at 05:14 AM. Reason: Added some answers

  4. #4
    Registered User
    Join Date
    04-06-2015
    Location
    paris
    MS-Off Ver
    Excel 2007 SP3, Excel 2021
    Posts
    14

    Re: Excel 2010 treats dates differently to excel 2013

    @HughTower,

    The VALUE(text) function in Excel takes a text and parses it to a internal date value by using the system locale (for dates, for floating-point numbers, ...).

    You can verify your system locale by going in the Windows control panel / regional settings / date-time tab.

    I suspect your two computers have different system locales. It's not a question over the fact that one uses Excel 2010 and the other Excel 2013.

  5. #5
    Registered User
    Join Date
    04-07-2015
    Location
    South africa
    MS-Off Ver
    2013
    Posts
    8

    Re: Excel 2010 treats dates differently to excel 2013

    Hi szwel

    Thankyou for your help.Busy downloading English option for win 8 64bit ( standard is US).
    I see the dates are different,Hope this is it!

    Regards
    Hugh

  6. #6
    Registered User
    Join Date
    04-07-2015
    Location
    South africa
    MS-Off Ver
    2013
    Posts
    8

    Re: Excel 2010 treats dates differently to excel 2013

    Thank you all!
    Problem solved.
    The system locales were different and excel was reading a date per the US and not Uk dd/mm/yyyy.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 11-09-2015, 01:59 AM
  2. Macro code working fine in excel 2013 but not in excel 2010.
    By sere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2014, 02:23 AM
  3. Worksheet_Activate works differently in Excel 2007 and 2010
    By rashroyer1066 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2014, 06:28 PM
  4. Outlook treats first email created by Excel differently
    By blackworx in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-15-2012, 08:32 AM
  5. Excel 2000 and 2010 recating differently
    By boltman7 in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 09:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1