Displaying formatted values as text
Displaying formatted values as text
The Excel TEXT function enables you to display a value in a specific number format. Although this
function may appear to have dubious value, it does serve some useful purposes, as the examples
in this section demonstrate. Figure 5-2 shows a simple worksheet.
formula =”The net profit is “ & B3
The Excel TEXT function enables you to display a value in a specific number format. Although this
function may appear to have dubious value, it does serve some useful purposes, as the examples
in this section demonstrate. Figure 5-2 shows a simple worksheet.
formula =”The net profit is “ & B3
Comments
Post a Comment