ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula Bar (https://www.excelbanter.com/excel-worksheet-functions/17995-formula-bar.html)

ronco405

Formula Bar
 
In older versions of Excel the formula bar had a "=" sign. The current
versions now have the function sign instead. Is there a way to change it
back. The "=" sign was exactly what we needed while the function sign does
not help us.

Don Guillett

I think it is set up that way so you can enter text in the selected cell
instead of a formula. Just touch the = key

--
Don Guillett
SalesAid Software

"ronco405" wrote in message
...
In older versions of Excel the formula bar had a "=" sign. The current
versions now have the function sign instead. Is there a way to change it
back. The "=" sign was exactly what we needed while the function sign does
not help us.




ronco405

Thank you for your response. However, when you select the "=" key, it wipes
out the contents of the cell. The old formula bar would add the "=" sign at
the beginning of the cell.

"Don Guillett" wrote:

I think it is set up that way so you can enter text in the selected cell
instead of a formula. Just touch the = key

--
Don Guillett
SalesAid Software

"ronco405" wrote in message
...
In older versions of Excel the formula bar had a "=" sign. The current
versions now have the function sign instead. Is there a way to change it
back. The "=" sign was exactly what we needed while the function sign does
not help us.





Gord Dibben

Gone as of 2002. No work-arounds.

You can move the = sign to your Toolbar but it does not bring up the Function
Wizard so is useless except for not having to type the = sign. Wheeee!!

Was not a popular move on the developers' part.

Perhaps re-structured in the next version after 2003.


Gord Dibben Excel MVP

On Wed, 16 Mar 2005 12:21:04 -0800, "ronco405"
wrote:

In older versions of Excel the formula bar had a "=" sign. The current
versions now have the function sign instead. Is there a way to change it
back. The "=" sign was exactly what we needed while the function sign does
not help us.



Don Guillett

Here, you add the = at the beginning.

--
Don Guillett
SalesAid Software

"ronco405" wrote in message
...
Thank you for your response. However, when you select the "=" key, it

wipes
out the contents of the cell. The old formula bar would add the "=" sign

at
the beginning of the cell.

"Don Guillett" wrote:

I think it is set up that way so you can enter text in the selected cell
instead of a formula. Just touch the = key

--
Don Guillett
SalesAid Software

"ronco405" wrote in message
...
In older versions of Excel the formula bar had a "=" sign. The current
versions now have the function sign instead. Is there a way to change

it
back. The "=" sign was exactly what we needed while the function sign

does
not help us.








All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com