[Finale] OT Time Signatures in Excel
Sorry for the OT post, and I did read the manual!Iam trying to enter data aboutmusical works in an Excel spreadsheet. I've figured out how to get a 3/4 time signature to display as 3/4 rather than March 4, but can't find a way to get 6/8 to remain as I enter it. Excel wants to reduce it to 3/4, and 2/4 to 1/2. Anyone know how to keep this from happening? TIA Erica Buxbaum Relax. Yahoo! Mail virus scanning helps detect nasty viruses!___ Finale mailing list Finale@shsu.edu http://lists.shsu.edu/mailman/listinfo/finale
Re: [Finale] OT Time Signatures in Excel
On 17 Feb 2006 at 15:05, eshbmusic1 wrote: Sorry for the OT post, and I did read the manual! I am trying to enter data about musical works in an Excel spreadsheet. I've figured out how to get a 3/4 time signature to display as 3/4 rather than March 4, but can't find a way to get 6/8 to remain as I enter it. Excel wants to reduce it to 3/4, and 2/4 to 1/2. Anyone know how to keep this from happening? TIA Erica Buxbaum Enter 3/4 instead of just 3/4. That tells Excel that you're entering text and not numbers. -- David W. Fentonhttp://dfenton.com David Fenton Associates http://dfenton.com/DFA/ ___ Finale mailing list Finale@shsu.edu http://lists.shsu.edu/mailman/listinfo/finale
Re: [Finale] OT Time Signatures in Excel
On Feb 17, 2006, at 6:05 PM, eshbmusic1 wrote: Sorry for the OT post, and I did read the manual! I am trying to enter data about musical works in an Excel spreadsheet. I've figured out how to get a 3/4 time signature to display as 3/4 rather than March 4, but can't find a way to get 6/8 to remain as I enter it. Excel wants to reduce it to 3/4, and 2/4 to 1/2. Anyone know how to keep this from happening? TIA Erica Buxbaum You don't say what you are using the data for, but if you format the cell as Text, it will keep the entries you make exactly as you enter them, and not reduce or transform them in any way. If you need the cell to stay numerical, you may be out of luck, but I can't imagine what would cause that need. Christopher ___ Finale mailing list Finale@shsu.edu http://lists.shsu.edu/mailman/listinfo/finale
RE: [Finale] OT Time Signatures in Excel
Have you tried to enter an apostrophe (unshifted quote)? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of eshbmusic1 Sent: Friday, February 17, 2006 6:05 PM To: finale@shsu.edu Subject: [Finale] OT Time Signatures in Excel Sorry for the OT post, and I did read the manual! Iam trying to enter data aboutmusical works in an Excel spreadsheet. I've figured out how to get a 3/4 time signature to display as 3/4 rather than March 4, but can't find a way to get 6/8 to remain as I enter it. Excel wants to reduce it to 3/4, and 2/4 to 1/2. Anyone know how to keep this from happening? TIA Erica Buxbaum Relax. Yahoo! Mail virus scanning helps detect nasty viruses! ___ Finale mailing list Finale@shsu.edu http://lists.shsu.edu/mailman/listinfo/finale
RE: [Finale] OT Time Signatures in Excel
Thanks, everyone! I found the info about formatting as text about two pages later! But haven't found the "3/4 solution, David, so thank you.Richard Willis [EMAIL PROTECTED] wrote:Hi again, Erica,If you want to do a row or column of time signatures, go to Format - Cell(s) - General and choose Text for the cells selected. That will ensure any numbers you enter will be treated not as numbers that could be reduced but as text.Hope this helps.RichardFrom: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of eshbmusic1Sent: Friday, February 17, 2006 6:05 PMTo: finale@shsu.eduSubject: [Finale] OT Time Signatures in Excel Sorry for the OT post, and I did read the manual!Iam trying to enter data aboutmusical works in an Excel spreadsheet. I've figured out how to get a 3/4 time signature to display as 3/4 rather than March 4, but can't find a way to get 6/8 to remain as I enter it. Excel wants to reduce it to 3/4, and 2/4 to 1! /2. Anyone know how to keep this from happening? TIAErica BuxbaumRelax. Yahoo! Mail virus scanning helps detect nasty viruses!___Finale mailing listFinale@shsu.eduhttp://lists.shsu.edu/mailman/listinfo/finale Yahoo! Mail Use Photomail to share photos without annoying attachments.___ Finale mailing list Finale@shsu.edu http://lists.shsu.edu/mailman/listinfo/finale
RE: [Finale] OT Time Signatures in Excel
Thanks, everyone! I found the info about formatting as text about two pages later! But haven't found the "3/4 solution, David, so thank you.Richard Willis [EMAIL PROTECTED] wrote:Hi again, Erica,If you want to do a row or column of time signatures, go to Format - Cell(s) - General and choose Text for the cells selected. That will ensure any numbers you enter will be treated not as numbers that could be reduced but as text.Hope this helps.RichardFrom: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of eshbmusic1Sent: Friday, February 17, 2006 6:05 PMTo: finale@shsu.eduSubject: [Finale] OT Time Signatures in Excel Sorry for the OT post, and I did read the manual!Iam trying to enter data aboutmusical works in an Excel spreadsheet. I've figured out how to get a 3/4 time signature to display as 3/4 rather than March 4, but can't find a way to get 6/8 to remain as I enter it. Excel wants to reduce it to 3/4, and 2/4 to 1! /2. Anyone know how to keep this from happening? TIAErica BuxbaumRelax. Yahoo! Mail virus scanning helps detect nasty viruses!___Finale mailing listFinale@shsu.eduhttp://lists.shsu.edu/mailman/listinfo/finale Brings words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail.___ Finale mailing list Finale@shsu.edu http://lists.shsu.edu/mailman/listinfo/finale