I am putting together a equipment table that has to have entries in metric. I
would like to set it up so that you type in the english units and it would
the convert into metric on the next line. However i have to have Brackets
around the Metric numbers...is there a way to do this?

How about this
Converting 1 foot into (0.3048) mtrs

="("&A18*0.3048&")"

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564852

You have failed to say which units you are working with but try this for inches
to centimeters.

In B1 enter =IF(A1="","",A1*2.54)

Drag/copy down column B

Format Column B to Custom (#,##0.00)

An event code solution if you wanted would be as follows...............

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in any cell in Col A
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
If Excel.Range("A" & n).Value < "" Then
Excel.Range("B" & n).Value = Excel.Range("A" & n).Value * 2.54
End If
End If
enditall:
Application.EnableEvents = True
End Sub

Format Column B to Custom (#,##0.00)


Gord Dibben MS Excel MVP


On Tue, 25 Jul 2006 11:55:03 -0700, Ms Serene <Ms
wrote:

I am putting together a equipment table that has to have entries in metric. I
would like to set it up so that you type in the english units and it would
the convert into metric on the next line. However i have to have Brackets
around the Metric numbers...is there a way to do this?

If you have feet in A1, to convert to metres in A2:
="("&CONVERT(A1,"ft","m")&")"

"Ms Serene" wrote:

I am putting together a equipment table that has to have entries in metric. I
would like to set it up so that you type in the english units and it would
the convert into metric on the next line. However i have to have Brackets
around the Metric numbers...is there a way to do this?

tried the formula you have below but couldn't get it to work.

"Martin P" wrote:

If you have feet in A1, to convert to metres in A2:
="("&CONVERT(A1,"ft","m")&")"

"Ms Serene" wrote:

I am putting together a equipment table that has to have entries in metric. I
would like to set it up so that you type in the english units and it would
the convert into metric on the next line. However i have to have Brackets
around the Metric numbers...is there a way to do this?

Martin's formula works fine for me assuming you want to convert imperial to
metric and also put parentheses around it. You must however have the Analysis
Toolpack add-In selected: Tools Add-Ins Analysis Toolpack checkbox

Regards,
Greg

"Ms Serene" wrote:

tried the formula you have below but couldn't get it to work.

"Martin P" wrote:

If you have feet in A1, to convert to metres in A2:
="("&CONVERT(A1,"ft","m")&")"

"Ms Serene" wrote:

I am putting together a equipment table that has to have entries in metric. I
would like to set it up so that you type in the english units and it would
the convert into metric on the next line. However i have to have Brackets
around the Metric numbers...is there a way to do this?

Would you like to give us a clue by telling us what result you got?

Did you look up the CONVERT function in Excel help?

Did that give you an answer?

David Biddulph

"Ms Serene" wrote in message
...
tried the formula you have below but couldn't get it to work.

"Martin P" wrote:

If you have feet in A1, to convert to metres in A2:
="("&CONVERT(A1,"ft","m")&")"

"Ms Serene" wrote:

I am putting together a equipment table that has to have entries in
metric. I
would like to set it up so that you type in the english units and it
would
the convert into metric on the next line. However i have to have
Brackets
around the Metric numbers...is there a way to do this?

You can format cells in Excell to display your data in any conceivable custom
format you want. Go to FORMAT, then CELLS, then CUSTOM. When you get to
that window enter the following "("##.## ")". The # signs refer to how many
digits and decimal places you want to show, so you may want something else
there. Anything that is enclosed by double quote marks will simply be
treated as a format. any numbers you then enter or calculate in a formatted
cell will display with brackets. I ofter format cells to read out with
attached words, such as 23.5 inches or 75 ohms, by putting the words "inches"
or "ohms" into the custom format window.
--
E. Polizzi


"Ms Serene" wrote:

I am putting together a equipment table that has to have entries in metric. I
would like to set it up so that you type in the english units and it would
the convert into metric on the next line. However i have to have Brackets
around the Metric numbers...is there a way to do this?