Excel question

  VNAM75 20:57 17 Nov 09
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 09

Try

="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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac