Building Estimator

Frank .S

<div>
thankyou zorvek, i ended up using the following formula to read L/H x 1<br />
@ [$x1]
</div>


thankyou zorvek, i ended up using the following formula to read L/H x 1
@ [$x1]

<div>
<div class="content wysiwyg-content fr-view">
hi experts i use the custom format cell many times but always with numeric values. This time i need it with a text value, so cell shows "L/H"and i want to format the cell to show 1x L/H, but the 2 options i can change the cell to are either L/H or R/H so i need format to just show 1x infront of any text value i enter in the cell.<br>How do i format the cells for this display?
</div>
</div>



hi experts i use the custom format cell many times but always with numeric values. This time i need it with a text value, so cell shows "L/H"and i want to format the cell to show 1x L/H, but the 2 options i can change the cell to are either L/H or R/H so i need format to just show 1x infront of any text value i enter in the cell.
How do i format the cells for this display?

excel 2016 - custom format cell with text value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.