Posted to microsoft.public.excel.worksheet.functions

derek_m_taylor

Posts: n/a

Formatting Cell To Display Value Instead Of Formula

The worksheet I am working on is actually used to input required data into
another worksheet. I don't want to just simply copy and paste the cells that
are needed because they contain a formula. Is there a way to format the
cells so the total is displayed vice the formula?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Is it possible?	DakotaNJ	Excel Worksheet Functions	25	September 18th 06 09:30 PM
Can I make a formula in Excel to display result in same cell?	Neiko	Excel Worksheet Functions	2	October 1st 05 10:36 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Display answer only in another cell of one containing a formula	Mally	Excel Discussion (Misc queries)	5	January 21st 05 01:07 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 06:58 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us