Part II: Working with Formulas and Functions
You can enter this formula into Excel to display 99.2:
=TEXT(99.21,"0.0")
An easy way to get the syntax for a particular number format in which you’re interested is to
look at the Number Format screen. Follow these steps:
- Right-click any cell and select Format Cell.
- On the Number Format tab, select the formatting you need.
- Select Custom from the Category list on the left of the Number Format dialog
box.
- Copy the syntax found in the Type input box.
Using the DOLLAR function
If the number value you’re joining with text is a dollar figure, you can use the simpler
DOLLAR function. This function applies the regional currency format to the given text.
The DOLLAR function has two basic arguments: the number value and the number of deci-
mals you want to display.
=B3&": "&DOLLAR(C3,0)
