Question

you can use customise the cell using dash format​

Answer 1

Answer:

Create a custom number format

Select the numeric data.

On the Home tab, in the Number group, click the Dialog box launcher.

Select Custom.

In the Type list, select an existing format, or type a new one in the box.

To add text to your number format: Type what you want in quotation marks. Add a space to separate the number and text.

Select OK.