| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting within a formula
I have done this before, but cannot remember how.
I am converting lbs to kg and using CONCATENATE to at the kg on the end of the formula Example: A1 = 220 lbs B1: =CONCATENATE(A1/2.2 &"kg) I need to reduce the answer in B1 to two decimal places. I believe I can do this within the formula, but not sure. Thanks for you help. Les |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formatting formula help!!! | Excel Discussion (Misc queries) | |||
| Formatting Formula | Excel Discussion (Misc queries) | |||
| Formula formatting | Excel Discussion (Misc queries) | |||
| Formula / Formatting Help - please!" | Excel Discussion (Misc queries) | |||
| Formatting in the formula bar | Excel Discussion (Misc queries) | |||
Threaded Mode
