Excel question

  VNAM75 20:57 17 Nov 2009
Locked

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 2009

Try

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

  VNAM75 21:51 17 Nov 2009

Thanks VoG™, works perfect.

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

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

HP’s new Surface Pro rival is designed specifically for Adobe-using designers and artists

Best kids apps for iPhone & iPad

Que faire si son iPhone ou iPad est tombé dans de l'eau ?