Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Apostrophes instead of equals in Excel
I've "inherited" someone else's office. The Excel on that computer is such if
I type an equals and a formula, it puts an apostrophe at the beginning and converts it to text. I can highlight and change back to an equals and it will calculate, but I shouldn't have to do this. If you don't type an equals and just input a simple calculation like division, it will calculate in the cell, but should you add something like an instruction to round the result, it adds the apostrophe and changes it to text again. I'm sure some setting has been changed. If you can steer me in the right direction, I'd be very appreciative. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |