Help with writing Text strings that pull data from cells (formatting troubles)

  • Thread starter Thread starter shadestreet
  • Start date Start date
S

shadestreet

I need help formating data that I am calling upon in a text string.

Lets say I am writing the sentence:

"The national debt grows by 4,000,000 dollars per day"

Lets say that the value of 4 million dollars is in cell C19, so I am
calling up that cell within my text string.

Now I just recently learned that I could change the format by using
&TEXT(C19, "0") to keep decimal points off, but I would like to make
sure there are commas in the value as well. I dont want it to say
4000000.

Thanks,
 
I figured it out myself, rather simple actually. Just put commas int
the text modifier.

e.g. &TEXT(C19, "0,000.00"
 
Back
Top