Ask Your Question

Formulae appear as text - how do I make it calculate (v.6 64-BIT

asked 2018-03-24 16:23:25 +0200

DHoff gravatar image

I've used several spreadsheets, including yours. When I type "=left(a4)" I hoped to get a number representing the length of the text string located at A4. All I get is the formula, and I can't figure out how to get around this. I've typed the formula directly and I've constructed it with the wizard, same result.

edit retag flag offensive close merge delete


what spreadsheet is named as "yours" here? i'm curious if the poster confuses spreadsheets (data) and spreadsheet software (Calc), and if the poster thinks that calling it "your" is OK when addressing to other users that help each other on the site.

Mike Kaganski gravatar imageMike Kaganski ( 2018-03-24 16:24:24 +0200 )edit

Yes, I meant :spreadsheet programs." I called it "your" because I thought I was addressing the question to the people who wrote the program.

DHoff gravatar imageDHoff ( 2018-03-25 18:51:13 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-03-24 16:31:48 +0200

Two possible reasons might be here:

  1. You have Show Formula view mode active (see it in menu View);
  2. Your cell is formatted as text (see Format->Cells). In this case, whatever you input into the cell, is treated as textual string, not a number or a formula, regardless if it can be interpreted as such. Choose a numeric format to resolve this case.
edit flag offensive delete link more



Also user has wrong function:

LEFT Returns the first character or characters of a text.

LEN Returns the length of a string including spaces.

From the Help file.

Ratslinger gravatar imageRatslinger ( 2018-03-24 17:20:10 +0200 )edit

answered 2018-03-25 18:52:33 +0200

DHoff gravatar image

It turns out I had "Show Formula" mode active. Thanks for the help!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-24 16:23:25 +0200

Seen: 42 times

Last updated: Mar 25 '18