Excel question

  VNAM75 20:57 17 Nov 09

I have a formula

="CASH"&":"&" "&SUM($B$3:$B$10) which gives me

CASH: 1000

How can I edit it so the value is formatted with a comma separator, ie

CASH: 1,000

  VoG II 21:35 17 Nov 09


="CASH"&":"&" "&TEXT(SUM($B$3:$B$10),"#,##0")

  VNAM75 21:51 17 Nov 09

Thanks VoG™, works perfect.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…