| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Include trailing zeroes in calculation
I have two columns formatted as numbers with two decimals. I want to concatenate these in a third column, including trailing zeroes.
For instance, if A1=100.10 and B1=110.20 the following calculation =A1&"x"&" "&B1&"y" should result in "110.10x 110.20y", NOT "110.1x 110.2y". I need those missing decimals! Thank you very much in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate and include trailing blanks | Excel Discussion (Misc queries) | |||
| IF Statements - to include calculation? | Excel Discussion (Misc queries) | |||
| eliminating trailing zeroes imported into word document from excel file | Excel Discussion (Misc queries) | |||
| Eliminating the zeroes from the calculation | Excel Discussion (Misc queries) | |||
| excel .txt to .cvs, lose trailing zeroes in numeric field | Excel Discussion (Misc queries) | |||
Linear Mode
