| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal Place goes crazy when using the "&" Sign.
Hi,
Basic Formula in A1 says: B1*C1. This works. I have all cells formatted to Number Format with 0 decimal place(s). I also have the 1000 separator (,) check box checked. If I change the same formula in A1 to: B1*C1&" lbs." .....A1 gives the right answer but shows a zillion decimal places with it. Is there a tip anyone could give me on what is happening and a suggestion for getting rid of the decimal places? Because of the &" lbs." does Excel maybe think the formula is text? I don't know. Thank-you in advance, Amy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Find" a wildcard as a place marker and "replace" with original va | Excel Discussion (Misc queries) | |||
| How to "sign" macro with "digital certificate"? | New Users to Excel | |||
| the "#" signs are driving me crazy :-( | New Users to Excel | |||
| Rounding errors when a "5" is the third decimal place using formul | Excel Discussion (Misc queries) | |||
| How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
Threaded Mode
