- Code: Select all
"Entrance fee "$0.00
Now all you enter in A1 is the number, for example 15, and Excel uses the text and number format for the purpose of display while =A1 in any other cell returns the number 15.
The same method is also useful for recurring texts like "Invoice No."
Entering a simple 1 in a cell formatted as
- Code: Select all
"Invoice No. "000000
To set the number format select the cell or range of cells you want to format,
Press Format / Cells on the Toolbar or Right-click and select 'Format Cells'
On the Number tab select Custom, and
Write the formatting mask in the Type field.