If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Custom formatting
I have a very large spreadsheet in which I need to change all dates that
appear this way: 1994 - 1995, to this: (1994 - 1995). Is there any way I can create a custom format for the latter? Otherwise I have to go through each cell one by one and change each one individually. I hope someone can help... |
#2
|
|||
|
|||
Custom formatting
If the data is in a column, then use a helper column. Say the data is in
column A. In B1 enter: ="(" & A1 & ")" and copy down. If you dates are scattered, then a macro is the best approach. -- Gary''s Student - gsnu200777 "Yvonne" wrote: I have a very large spreadsheet in which I need to change all dates that appear this way: 1994 - 1995, to this: (1994 - 1995). Is there any way I can create a custom format for the latter? Otherwise I have to go through each cell one by one and change each one individually. I hope someone can help... |
#3
|
|||
|
|||
Custom formatting
On Apr 3, 11:50*pm, Gary''s Student
wrote: If the data is in a column, then use a helper column. *Say the data is in column A. *In B1 enter: ="(" & A1 & ")" and copy down. If you dates are scattered, then a macro is the best approach. -- Gary''s Student - gsnu200777 "Yvonne" wrote: I have a very large spreadsheet in which I need to change all dates that appear this way: 1994 - 1995, to this: (1994 - 1995). * Is there any way I can create a custom format for the latter? *Otherwise I have to go through each cell one by one and change each one individually.. I hope someone can help...- Hide quoted text - - Show quoted text - Or as a custom format: (@) Cheers, Ivan. |
#4
|
|||
|
|||
Custom formatting
Thanks, it is helpful, but I am relatively new to Excel, and I'm not familiar
with macros. The dates are scattered. I need this: National Yeast 1950-1951,1955-1957; General Motors 1954-1955; Parker Sheet Metal 1956-1960; Sun Oil Co., 1965-1986 to look like this: National Yeast (1950-1951,1955-1957); General Motors (1954-1955); Parker Sheet Metal (1956-1960); Sun Oil Co., (1965-1986) We have a database at work that runs reports, and puts all information into an Excel document. If the information isn't entered correctly into our database in the first place, then we are left to clean up the mess in the reports. It wastes a great deal of time, and I was hoping there might be a way to cut back on that time. Is there a macro for me somewhere out there? "Gary''s Student" wrote: If the data is in a column, then use a helper column. Say the data is in column A. In B1 enter: ="(" & A1 & ")" and copy down. If you dates are scattered, then a macro is the best approach. -- Gary''s Student - gsnu200777 "Yvonne" wrote: I have a very large spreadsheet in which I need to change all dates that appear this way: 1994 - 1995, to this: (1994 - 1995). Is there any way I can create a custom format for the latter? Otherwise I have to go through each cell one by one and change each one individually. I hope someone can help... |
#5
|
|||
|
|||
Custom formatting
On Apr 4, 1:25*am, Yvonne wrote:
Thanks, it is helpful, but I am relatively new to Excel, and I'm not familiar with macros. * The dates are scattered. *I need this: National Yeast 1950-1951,1955-1957; General Motors 1954-1955; Parker Sheet Metal 1956-1960; Sun Oil Co., 1965-1986 to look like this: National Yeast (1950-1951,1955-1957); General Motors (1954-1955); Parker Sheet Metal (1956-1960); Sun Oil Co., (1965-1986) We have a database at work that runs reports, and puts all information into an Excel document. *If the information isn't entered correctly into our database in the first place, then we are left to clean up the mess in the reports. *It wastes a great deal of time, and I was hoping there might be a way to cut back on that time. Is there a macro for me somewhere out there? * "Gary''s Student" wrote: If the data is in a column, then use a helper column. *Say the data is in column A. *In B1 enter: ="(" & A1 & ")" and copy down. If you dates are scattered, then a macro is the best approach. -- Gary''s Student - gsnu200777 "Yvonne" wrote: I have a very large spreadsheet in which I need to change all dates that appear this way: 1994 - 1995, to this: (1994 - 1995). * Is there any way I can create a custom format for the latter? *Otherwise I have to go through each cell one by one and change each one individually. I hope someone can help...- Hide quoted text - - Show quoted text - Hi Yvonne, Where you write the example, do the semicolons represent different cells? i.e. is the data as such: cell A1: "National Yeast 1950-1951" cell A2: "General Motors 1954-1955" cell A3: "Parker Sheet Metal 1956-1960" cell A4: "Sun Oil Co., 1965-1986" etc... or do they run across in a row, or is the whole thing just one big string in a cell? Shouldn't be hard to write a macro for it, but the more info we have on the structure of your data te easier it will be. Cheers, Ivan. |
Thread Tools | |
Display Modes | |
|
|