ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pls. help... (https://www.excelbanter.com/excel-discussion-misc-queries/146773-pls-help.html)

Nad

pls. help...
 
Hi,
When i write any formula in any cell (e.g. =LEFT(A4,5), it doesn't executes.
It display like a text message.
Plz help .

Max

pls. help...
 
Probably the cell was pre-formatted as text, unknown to you. Try
re-formatting the cell as either General or number, then *re-enter* the
formula by clicking inside the formula bar, press ENTER.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nad" wrote:
Hi,
When i write any formula in any cell (e.g. =LEFT(A4,5), it doesn't executes.
It display like a text message.
Plz help .



All times are GMT +1. The time now is 04:09 PM.

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