Formula entry in Excel

Jason Morin

Posts: n/a

Most likely the cell is set to text. Thus anything you enter will be
interpreted as text, including a formula.

This can happen if you insert a new column between columns, and the column
to the left of the inserted column is text.

HTH
Jason
Atlanta, GA

"David Boas" wrote:

Why, occasionally, when I enter a formula into a cell, I get the formula
displayed rather than the result?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I prevent Excel from plotting a cell w/ a formula as a "ze.	Hatchet_Jack	Charts and Charting in Excel	1	February 9th 05 10:31 PM
How do I prevent Excel from plotting a cell w/ a formula as a "ze.	Bearclaw Chris	Charts and Charting in Excel	0	February 9th 05 04:59 PM
excel formula	BONNY	Excel Discussion (Misc queries)	1	January 13th 05 05:03 PM
How do i make journal entry in excel?	Natali	Excel Worksheet Functions	2	January 5th 05 06:09 PM
Converting an Excel formula to an Access query formula	Adam	Excel Discussion (Misc queries)	1	December 15th 04 03:38 AM

All times are GMT +1. The time now is 05:38 PM.

Menu

About Us