auto format

riordanc

New Member

Join Date: Apr 2010

Posts: 2

27th Apr 2010

Hi!

I have recently switched to a new computer using windows 7

In the past, in order to auto format a large amount of cells with a formula and values, all I would have to do was enter the formula in a couple of cells and then click on them and drag.

Now, clicking and dragging put the formulas into the new cells, but the value does not show until I click on each individual cells formula bar and press enter.

Could someone please tell me how to set the auto format so that the value is copied and shown automatically (and not just the formula)

Thanks

« "Can not empty the clipboard" | FDIST Function »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ignore auto format after applying a custom format??	jigglepop	Microsoft Excel Misc	0	2nd Apr 2008 04:17 PM
Excel Auto-Format cell to email format	=?Utf-8?B?UGxlYXNlIEhlbHAgTWU=?=	Microsoft Excel Misc	1	23rd Mar 2006 05:15 PM
auto format help	coastalcarolina	Microsoft Excel Misc	2	31st Jan 2006 03:41 PM
How can I auto format the fraction 1/8 like Word format automatic.	=?Utf-8?B?SnVkaQ==?=	Microsoft Access Getting Started	3	3rd Mar 2005 02:22 PM
Prevent excel to auto format and auto apply formula to a cell when opening a file	MikeVince	Microsoft Excel Misc	2	27th Feb 2004 02:37 AM