Thread: How do I stop excel from changing my ratios into time format?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Marcelo
 
Posts: n/a
Default How do I stop excel from changing my ratios into time format?
Hi, format the range as text

HTH
regards from Brazil
Marcelo

"Qlmmb2000" escreveu:

I'm trying to type ratios such as "0:1:0" into my excel spredsheet. Excel,
in its infinite wisdom, keeps changing it to "12:01:00 AM." How do I tell
excel to leave the cell alone after I type what I WANT to go into it?
Reply With QuoteReply With Quote