Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Equal sign in toolbar

I'm using Excel 2003 SP2. I used to use Excel 2000 and I've noticed
something in 2003 that is annoying me but I can't seem to find how to change
it to what I used to see in 2000.

I have 4 bars at the top of the window when I have a spreadsheet open.
File Edit View Insert etc
Toolbar with icons showing new, open file, save file etc
Another toolbar with icons for font, font size, bold, italicize etc
The last bar shows the cell I'm sitting in, and the formula if applicable,
otherwise this box is blank.

In 2000 this last bar used to have an = sign directly to the left of the
spot that displays the formula. If I entered a number into a cell (ie
23.98), hit enter and moved on then later came back and realized I now needed
a formula (23.98+45.21) then I would left click on the equal sign with the
mouse and it would enter an = into the beginning of the cell and my cursor
would go to the right of the 8 in 23.98 ready for further input. In 2003
there is an italicized fx instead of the = sign. What happened to the =?
How do I put it back instead of or in addition to the italicized fx.

Hopefully this makes sense. I have a multipage spreadsheet for my budget
and I don't always think to put in the = and having that = sign beside the
display box for the formula made life a lot easier.

Thanks for any input,
Pamala
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Equal sign in toolbar

This was changed in version 2002 and has remained through 2003 in spite of it
not being a very popular move by Excel Developers.

No way to get it back.

You can place the "=" sign on the Toolbar but functionality is not the same.
It just enters an "=" sign in the cell.

But note when you enter the "=" sign in the cell a list of Functions appears in
the NameBox.


Gord Dibben Excel MVP




On Wed, 21 Feb 2007 16:32:18 -0800, PureEvil
wrote:

I'm using Excel 2003 SP2. I used to use Excel 2000 and I've noticed
something in 2003 that is annoying me but I can't seem to find how to change
it to what I used to see in 2000.

I have 4 bars at the top of the window when I have a spreadsheet open.
File Edit View Insert etc
Toolbar with icons showing new, open file, save file etc
Another toolbar with icons for font, font size, bold, italicize etc
The last bar shows the cell I'm sitting in, and the formula if applicable,
otherwise this box is blank.

In 2000 this last bar used to have an = sign directly to the left of the
spot that displays the formula. If I entered a number into a cell (ie
23.98), hit enter and moved on then later came back and realized I now needed
a formula (23.98+45.21) then I would left click on the equal sign with the
mouse and it would enter an = into the beginning of the cell and my cursor
would go to the right of the 8 in 23.98 ready for further input. In 2003
there is an italicized fx instead of the = sign. What happened to the =?
How do I put it back instead of or in addition to the italicized fx.

Hopefully this makes sense. I have a multipage spreadsheet for my budget
and I don't always think to put in the = and having that = sign beside the
display box for the formula made life a lot easier.

Thanks for any input,
Pamala


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Equal sign in toolbar

Thanks for letting me know, I kind of figured that was the case but thought
I'd asked. (I love this forum, I get all sorts of questions answered!)
Another thing to add to the list of annoying updates from the developers.
It's almost like the developers don't actually use the programs they design.
Maybe it will get corrected in 2007? Or is that just wishful thinking?

Pamala

"Gord Dibben" wrote:

This was changed in version 2002 and has remained through 2003 in spite of it
not being a very popular move by Excel Developers.

No way to get it back.

You can place the "=" sign on the Toolbar but functionality is not the same.
It just enters an "=" sign in the cell.

But note when you enter the "=" sign in the cell a list of Functions appears in
the NameBox.


Gord Dibben Excel MVP




On Wed, 21 Feb 2007 16:32:18 -0800, PureEvil
wrote:

I'm using Excel 2003 SP2. I used to use Excel 2000 and I've noticed
something in 2003 that is annoying me but I can't seem to find how to change
it to what I used to see in 2000.

I have 4 bars at the top of the window when I have a spreadsheet open.
File Edit View Insert etc
Toolbar with icons showing new, open file, save file etc
Another toolbar with icons for font, font size, bold, italicize etc
The last bar shows the cell I'm sitting in, and the formula if applicable,
otherwise this box is blank.

In 2000 this last bar used to have an = sign directly to the left of the
spot that displays the formula. If I entered a number into a cell (ie
23.98), hit enter and moved on then later came back and realized I now needed
a formula (23.98+45.21) then I would left click on the equal sign with the
mouse and it would enter an = into the beginning of the cell and my cursor
would go to the right of the 8 in 23.98 ready for further input. In 2003
there is an italicized fx instead of the = sign. What happened to the =?
How do I put it back instead of or in addition to the italicized fx.

Hopefully this makes sense. I have a multipage spreadsheet for my budget
and I don't always think to put in the = and having that = sign beside the
display box for the formula made life a lot easier.

Thanks for any input,
Pamala



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Equal sign in toolbar

I don't use 2007 which has been out for a few months but I think the missing "="
sign rermains.

A 2007 user could tell us.

hint, hint, nudge, nudge. know what I mean? know what I mean?


Gord Dibben MS Excel MVP

On Thu, 22 Feb 2007 13:58:18 -0800, PureEvil
wrote:

Thanks for letting me know, I kind of figured that was the case but thought
I'd asked. (I love this forum, I get all sorts of questions answered!)
Another thing to add to the list of annoying updates from the developers.
It's almost like the developers don't actually use the programs they design.
Maybe it will get corrected in 2007? Or is that just wishful thinking?

Pamala

"Gord Dibben" wrote:

This was changed in version 2002 and has remained through 2003 in spite of it
not being a very popular move by Excel Developers.

No way to get it back.

You can place the "=" sign on the Toolbar but functionality is not the same.
It just enters an "=" sign in the cell.

But note when you enter the "=" sign in the cell a list of Functions appears in
the NameBox.


Gord Dibben Excel MVP




On Wed, 21 Feb 2007 16:32:18 -0800, PureEvil
wrote:

I'm using Excel 2003 SP2. I used to use Excel 2000 and I've noticed
something in 2003 that is annoying me but I can't seem to find how to change
it to what I used to see in 2000.

I have 4 bars at the top of the window when I have a spreadsheet open.
File Edit View Insert etc
Toolbar with icons showing new, open file, save file etc
Another toolbar with icons for font, font size, bold, italicize etc
The last bar shows the cell I'm sitting in, and the formula if applicable,
otherwise this box is blank.

In 2000 this last bar used to have an = sign directly to the left of the
spot that displays the formula. If I entered a number into a cell (ie
23.98), hit enter and moved on then later came back and realized I now needed
a formula (23.98+45.21) then I would left click on the equal sign with the
mouse and it would enter an = into the beginning of the cell and my cursor
would go to the right of the 8 in 23.98 ready for further input. In 2003
there is an italicized fx instead of the = sign. What happened to the =?
How do I put it back instead of or in addition to the italicized fx.

Hopefully this makes sense. I have a multipage spreadsheet for my budget
and I don't always think to put in the = and having that = sign beside the
display box for the formula made life a lot easier.

Thanks for any input,
Pamala




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Formula bar doesn't have an equal sign Joes Auto Pat Excel Worksheet Functions 1 June 16th 06 08:06 PM
Why a plus sign after the equal sign? [email protected] Excel Discussion (Misc queries) 3 June 5th 06 06:42 PM
Equal Sign As Text Trussy Excel Discussion (Misc queries) 1 January 5th 06 11:56 PM
EQUAL SIGN K Nguyen Excel Discussion (Misc queries) 2 December 15th 05 07:30 PM
Equal Sign Issue Jedidia Excel Worksheet Functions 2 June 28th 05 04:13 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"