Formula to Value

T

tghcogo

Hi there

I have just updated to from 2000 to 2003, and cannot find a toolbar
button for formula to value. I can copy and paste special in the same
cell, but this is mildly irritating.

Am I being dumb?

TGHCOGO
 
P

Peo Sjoblom

I don't think it has ever been there without help at least.
Do as follows:

click view>toolbars>customize, select commands, select edit in the left pane
and scroll down until you see
something that looks like an old time almanac date that you would tear off
every day |12| it has a 12 in it,
paste values is the name, now select and left click with the mouse and drag
it to your toolbar, preferably close to the copy button. Then close the
customize window

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
R

Ron de Bruin

Hi

You can add it it to one of your toolbars

Tools|Customize|commands Tab
In the Edit categorie drag the button with 12 on it to one of your toolbars
 
Top