G Guest Dec 14, 2005 #1 How do I use the colon without it converting to time. For example when I enter 1:2, it automatically converts to 1:02?
How do I use the colon without it converting to time. For example when I enter 1:2, it automatically converts to 1:02?
G Guest Dec 14, 2005 #3 I think you may need to set the number format for those cells to text. Format>Cells>Number tab Category: Text Alternatively, the Fraction number format may work for you. Does that help? *********** Regards, Ron
I think you may need to set the number format for those cells to text. Format>Cells>Number tab Category: Text Alternatively, the Fraction number format may work for you. Does that help? *********** Regards, Ron
