I just tried it on 03 and it didnt work either it returned 5000 back

"Raz" wrote:

hmm, it works fiine in mine, are you using excel 2007?

try adding brackets and quatation signs, for example
="500"&(A1+A2)


"Té" wrote:

When I tried that it said it was a circular reference and it came back 0

"Raz" wrote:

try this:
=500&A1+A2

If you want space between two then use this

=500&" "&A1+A2

You can add as many equations or text as u like, just add &

Let me know it it worked