?
Solved

Format() function missing in Excel 2007

Posted on 2009-12-27
2
Medium Priority
?
322 Views
Last Modified: 2012-05-08
I am missing the format() function in Excel 2007.
I think, I installed all options for Excel,
0
Comment
Question by:olio
  • 2
2 Comments
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 200 total points
ID: 26128941
There is no FORMAT function in Excel - never has been. It's TEXT.

Kevin
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 26128945
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?

Kevin
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New style of hardware planning for Microsoft Exchange server.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

839 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