Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula bar doesn't have an equal sign | Excel Worksheet Functions | |||
Why a plus sign after the equal sign? | Excel Discussion (Misc queries) | |||
Equal Sign As Text | Excel Discussion (Misc queries) | |||
EQUAL SIGN | Excel Discussion (Misc queries) | |||
Equal Sign Issue | Excel Worksheet Functions |