Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff
 
Posts: n/a
Default Can you change something in Excel to automatically insert an equa.

I'm generally used to Lotus 1-2-3 where for a calculation I can just enter
1+2 and have it display 3. In Excel I always have to enter =1+2. If you
don't enter the = it will just display 1+2 after you hit enter. Is there
something in the settings you can change so that it will automatically enter
the = sign?
  #2   Report Post  
swatsp0p
 
Posts: n/a
Default

The only other option is to enter "+1+2" which will return 3

This is an Excel requirement. A tradeoff from Lotus is if you WANT the cell
to display "1+2" in Lotus, you must enter the apostrophe " '1+2 ", in Excel,
you don't.

HTH

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
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
Setting today's date automatically in Excel. Ezlpo Excel Worksheet Functions 6 February 11th 05 02:27 PM
Can an excel cell automatically change fill colors based on values John Clark Excel Discussion (Misc queries) 1 February 5th 05 05:21 PM
how do I change the text case of imported data in excel? ArtLene Excel Discussion (Misc queries) 1 January 26th 05 07:08 AM
Enter Data Into Another Excel File Automatically Morrisg Excel Worksheet Functions 0 January 11th 05 02:07 AM


All times are GMT +1. The time now is 02:00 AM.

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

About Us

"It's about Microsoft Excel"