Keeping Decimal Places in Formulas

[excellingatmyjob]

Help!

I have users input a number into a cell. I want that number to automatically format to have 2 decimal places. Then I am using that number and equation to auto-fill another section that has units also autofill in the cell. See below:



Left = Auto-filled from right side entry Right = user input data

A1 B1 C1 D1

A1

B1

C1

D1

<tbody>
</tbody>

Total Heat Rejection:

733 MBH

Total Heat Rejection:

733.00

<tbody>
</tbody>

So, the user inputs data into D1, the cell is formatted to have 2 decimal spaces

The formula in B1 = =D1&" MBH"

How do I get B1 to display 733.00 MBH - keeping the decimal places.

Thank you!

 

[VoG]

Try

=TEXT(D1,"0.00")&" MBH"

 

[Rick Rothstein]

Left = Auto-filled from right side entry Right = user input data

A1 B1 C1 D1

A1

B1

C1

D1

<tbody>
</tbody>

Total Heat Rejection:

733 MBH

Total Heat Rejection:

733.00

<tbody>
</tbody>

So, the user inputs data into D1, the cell is formatted to have 2 decimal spaces

The formula in B1 = =D1&" MBH"

How do I get B1 to display 733.00 MBH - keeping the decimal places.

Two ways...

First method: You could Custom Format the cell using this Type pattern... 0.00" MBH"

Second method: Use this formula instead of the above Custom Format... =TEXT(D1,"0.00"" MBH"""

The difference is that the first method's result will be a number (still usable in calculations) and the second method's result will be text.