?
Solved

Excel 2010 - Same Formula giving me two different results

Posted on 2013-01-13
3
Medium Priority
?
353 Views
Last Modified: 2013-01-22
I type the same formula into to different cells and get two different results (see graphic).
Why?
err
0
Comment
Question by:brothertruffle880
3 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 38771496
Hello,

A2 is probably formatted as Text. Format the cell as General, then hit F2 and Enter.

cheers, teylyn
0
 
LVL 35

Expert Comment

by:Rob Henson
ID: 38774124
Looking at your screen shot, A2 & A3 are not the same.

A2 is concatenating columns B to E on row 2
A3 is concatenating columns B to E on row 3

Are the contents of B2 to E2 the same as B3 to E3?

Thanks
Rob H
0
 

Author Closing Comment

by:brothertruffle880
ID: 38807784
PERFECT.  Thank you once again!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering.  This article seeks by illustration …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question