Basic format problem
This has driven me insane for years! I type =a14+a15 and the cell display is
=a14+a15. Instead of treating it as a function and providing a result I only see the formula displayed as text within the cell. The above calc was just a sample and I usually find a way around it but this happens to me more and more often. Any help would be appreciated.. -- Ray |
Basic format problem
hi Ray,
try: 1. check if the cell is formated as text, format it as general and try again. 2. Tools | Options | exibity box and uncheck formula hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Ray" escreveu: This has driven me insane for years! I type =a14+a15 and the cell display is =a14+a15. Instead of treating it as a function and providing a result I only see the formula displayed as text within the cell. The above calc was just a sample and I usually find a way around it but this happens to me more and more often. Any help would be appreciated.. -- Ray |
Basic format problem
You need to do two things prior to entering a formula:
1. Insure that Tools Options... View and Formulas is un-checked 2. Insure that the cell is not formatted to Text -- Gary's Student "Ray" wrote: This has driven me insane for years! I type =a14+a15 and the cell display is =a14+a15. Instead of treating it as a function and providing a result I only see the formula displayed as text within the cell. The above calc was just a sample and I usually find a way around it but this happens to me more and more often. Any help would be appreciated.. -- Ray |
All times are GMT +1. The time now is 06:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com