| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help with displaying 0's after decimals
Hi,
I have 2 cells. One with the number that has 2 decimals and one with text. When I use the "&" function to combine the 2 into 1 cell, all of the numbers with the 0 at the end disappear. Example: cell 1: 3.80, cell 2: +80. cell1&cell2 resulted in 3.8 +80 instead of 3.80 +80. Any help would be appreciated. mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimals, how? | Excel Discussion (Misc queries) | |||
| Displaying zeroes in decimals | Excel Discussion (Misc queries) | |||
| no decimals | Excel Discussion (Misc queries) | |||
| Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
| Displaying decimals that go in to a given number | Excel Discussion (Misc queries) | |||
Threaded Mode
