RE: [Finale] OT Time Signatures in Excel

2006-02-17 Thread eshbmusic1
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.     Richard     From: [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! 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? 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


RE: [Finale] OT Time Signatures in Excel

2006-02-17 Thread eshbmusic1
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.     Richard     From: [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! 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? 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

2006-02-17 Thread Richard Willis








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.

 

Richard

 









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!





 





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









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

2006-02-17 Thread Owain Sutton
Select relevant cells - right click - format cells - 'number' tab - 
choose 'Text' as the category



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


Relax. Yahoo! Mail virus scanning 
 
helps detect nasty viruses!





___
Finale mailing list
Finale@shsu.edu
http://lists.shsu.edu/mailman/listinfo/finale

___
Finale mailing list
Finale@shsu.edu
http://lists.shsu.edu/mailman/listinfo/finale


RE: [Finale] OT Time Signatures in Excel

2006-02-17 Thread Richard Willis








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!





 





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









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

2006-02-17 Thread Christopher Smith


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

2006-02-17 Thread David W. Fenton
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