How do I format the results of these numbers, so that I can get rid of the decimal places?
A Alex May 25, 2004 #1 How do I format the results of these numbers, so that I can get rid of the decimal places?
P Peo Sjoblom May 25, 2004 #2 What numbers? Maybe text? ="Here is your text "&TEXT(123,"$#,##0.00") would return Here is your text $123.00 -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
What numbers? Maybe text? ="Here is your text "&TEXT(123,"$#,##0.00") would return Here is your text $123.00 -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
J Jason Morin May 25, 2004 #3 Maybe this example will help: ="I drink "&TEXT(13/3,"#")&" beers every night." HTH Jason Atlanta, GA
