Format() function missing in Excel 2007

Posted on 2009-12-27
Last Modified: 2012-05-08
I am missing the format() function in Excel 2007.
I think, I installed all options for Excel,
Question by:olio
    LVL 81

    Accepted Solution

    There is no FORMAT function in Excel - never has been. It's TEXT.

    LVL 81

    Expert Comment

    by:zorvek (Kevin Jones)
    Unless you are in VBA in which case you may have a corrupt Excel installation. The VBA/VB Format function is not an install option. Are you working with an existing project? What happens when you code that function in a new empty workbook?


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    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…
    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    728 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

    15 Experts available now in Live!

    Get 1:1 Help Now