Format in excel

Posted on 2011-05-11
Last Modified: 2012-05-11

I have a big problem.
I have to export from a program a excel list.
I made the excel export from two diffrent computers. The first computer is exporting the list ok but the second one is putting date values instead of numbers.
(Please see the attachment!)

I think the excel options are diffrent. Please, can you  tell me what to chang in order to generate the same list.

Thank you,

Question by:Qw M
    LVL 31

    Expert Comment

    by:Rob Henson
    The only one that I can think of within Excel is the Lotus transition settings.

    Tools > Options > Transition tab > Two boxes at the bottom to determine how entries are made and evaluated.

    Entry in Lotus will assume 11/5/2011 is a formula and will give 0.00109 whereas Excel will automaticall recognise it as a date. To force it as a formula needs to be =11/5/2011

    Rob H
    LVL 13

    Accepted Solution

    I think you should examine the regional settings in the Control Panel. There could be a difference in date formats that make Excel interpretation different.

    Best regards,

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now