In Excel 2000 - When you go to a cell that has a number already there and you
want to add to it there is an = sign on your formula bar that you can hit and
it automatically puts it in front of the number and you just hit and the
number to add. How do you get that = sign there in Excel 2003?
Thanks
Right click on your toolbar, select Customize. Select the Commands tab.
Select Insert from the list onthe left. Scroll down the list on the
right until you find the quot;=quot;, quot; quot; or whatever mathematic operator you
want to add. Select and drag it to the toolbar where you want it to be
located.
HTH
Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=509522I've tried that but when you hit the = it works if there is nothing in the
cell but if there is a number already in the cell and you want to add to it,
it blanks that number out and just puts the new number in. I know in Excel
2000 where the fx is in 2003 there used to be an =. I would like to change
the fx to an = but don't know if I can or how to do it.
quot;tadquot; wrote:
gt; In Excel 2000 - When you go to a cell that has a number already there and you
gt; want to add to it there is an = sign on your formula bar that you can hit and
gt; it automatically puts it in front of the number and you just hit and the
gt; number to add. How do you get that = sign there in Excel 2003?
gt;
gt; Thanks
gt;
gt;
Actually, MS eliminated it in xl2002.
But there is an equal sign icon that you can add to your favorite toolbar.
Tools|Customize|Commands tab|Insert Category
(a little more than half way down the commands list.)
tad wrote:
gt;
gt; In Excel 2000 - When you go to a cell that has a number already there and you
gt; want to add to it there is an = sign on your formula bar that you can hit and
gt; it automatically puts it in front of the number and you just hit and the
gt; number to add. How do you get that = sign there in Excel 2003?
gt;
gt; Thanks
--
Dave Peterson
- May 16 Wed 2007 20:37
Formula Bar
close
全站熱搜
留言列表
發表留言