excellingatmyjob
New Member
- Joined
- Aug 19, 2014
- Messages
- 4
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
<tbody>
</tbody>
<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!
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!