| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autoformatting [##,###] (##,###)
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autoformatting [##,###] (##,###)
Apply custom cell format:
(0.00) Regards, Stefi €˛myra_deV€¯ ezt Ć*rta: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autoformatting [##,###] (##,###)
="(" & LEFT(A1,FIND(",",A1)-1) & ", " & RIGHT(A1,LEN(A1)-FIND(",",A1)) & ")"
"myra_deV" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems with autoformatting revisited | Excel Discussion (Misc queries) | |||
| fields formated as 3-8-18 autoformatting to date on when exported | Excel Discussion (Misc queries) | |||
| Autoformatting of cells in csv files on opening. | Excel Discussion (Misc queries) | |||
| How do I stop Excel 2002 from autoformatting numbers into dates? | Excel Discussion (Misc queries) | |||
| autoformatting issues in excel | Excel Discussion (Misc queries) | |||
Linear Mode
