ESI Tech

Ever been frustrated with Microsoft Excel when you have been working with a cell but you want to show the units of the cell such as five Kgs, five Bags or four Punnets but Microsoft Excel keeps turning the cell into text. Well, there is in reality a way of producing a custom format in Microsoft Excel that lets you show the units of the worth whilst nevertheless keeping the value becoming treated as a quantity.

Nicely, 1st off we call for to get into the Format Cells dialog box in Microsoft Excel as this is the dialog box that allows you to create a custom format but prior to you do that make sure that you have selected the cell that you want to apply the format to.

Positive Format Negative Format Zero Format

#,##.00 “kg” -#,##.00 “kg” .00 “kg”

The symbol says that if there is a number, show the number but if there is no number in that position location a zero in its location. The minus symbol in the negative format signifies that even if you sort the number in with brackets around the worth, the application will convert the brackets to a negative symbol at the begin of the cell.

Now the Custom format has been applied enter a worth of 5 into the cell and press the [Enter] critical.

Filed under: Microsoft software