autoformatting [##,###] (##,###)

[Guest]

does anyone have an idea how i can automatically change a row of numbers so
that they are put within brackets?

example
row 1: 12,5 10,4 11,3 18,56

i want:
(12,5) (10,4) (11,3) (18,56)

is there an autoformat somewhere in excel?
i am now doing it by hand. but i have another 200 to go and there has to be
an easier way!!

Thnx

 

[Guest]

Apply custom cell format:
(0.00)

Regards,
Stefi

„myra_deV†ezt írta:

 

[Guest]

="(" & LEFT(A1,FIND(",",A1)-1) & ", " & RIGHT(A1,LEN(A1)-FIND(",",A1)) & ")"