Adding logical values

  • Thread starter Thread starter Veronique
  • Start date Start date
V

Veronique

I tried to add a range of cells which values came from a
function and the result was 0. It didn't seem to
understand the result of my function as a true number.

any hint on how to add this range of cells?

Thanks much,
(e-mail address removed)
 
They are probably text-formatted if a text function has created them as in:

=LEFT(A1,2)

while A1 houses something like 215 or 21A.

=--LEFT(A1,2)

or

=LEFT(A1,2)+0

would make the result a true number.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel Need Countifs Formula Help 0
Function to put worksheet name in cell returns text, need number 5
adding text according to col with equal date 2
Question about conditional formatting of zeros in Excel 0
Is there a function to perform this operation? 2
Logical Test on Date value 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0

Back
Top