• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Excel 2010 - Same Formula giving me two different results

I type the same formula into to different cells and get two different results (see graphic).
Why?
err
0
brothertruffle880
Asked:
brothertruffle880
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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

cheers, teylyn
0
 
Rob HensonIT & Database AssistantCommented:
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
 
brothertruffle880Author Commented:
PERFECT.  Thank you once again!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now