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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting within a formula
Try
=CONCATENATE(TEXT(A1/2.2,"00.00"))&"Kg" Mike "WLMPilot" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting within a formula
A better solution would be to use a custom format of
00.00"Kg" in B1. that way the underlying value isn't changed and you can still do math on it. Mike "Mike H" wrote: Try =CONCATENATE(TEXT(A1/2.2,"00.00"))&"Kg" Mike "WLMPilot" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting within a formula
This kept returning a value of 00.00kg. However, your other option worked.
I could not figure out how to set the custom format up. Thanks, Les "Mike H" wrote: Try =CONCATENATE(TEXT(A1/2.2,"00.00"))&"Kg" Mike "WLMPilot" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting within a formula
hi
another way... =CONCATENATE(ROUND(A1/2.2,2) &" kg) regards FSt1 "WLMPilot" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting within a formula
I might be able to help you out, I say might because my excel is translated
and i might not spell right the items. Formatcell(from the menu select custom). now, you have to figure out the way you need the data to be displayed, after that. there is a type box that alows you to change. and on top of it there is the sample. in the end of whatever way you pick. there comes your customisation. the Kg will not be part of the data from the cel. and you add it by typing in the type box " #.##0,00 \k\g " "WLMPilot" wrote: This kept returning a value of 00.00kg. However, your other option worked. I could not figure out how to set the custom format up. Thanks, Les "Mike H" wrote: Try =CONCATENATE(TEXT(A1/2.2,"00.00"))&"Kg" Mike "WLMPilot" wrote: 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 |
Reply |
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) |