I want brackets around my math equation answer?

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

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
Serene@discussions.microsoft.com> 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" <MsSerene@discussions.microsoft.com> wrote in message
news:989D80A4-1305-41DF-BC5A-7D5EB301CC05@microsoft.com...
> 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?