Forum Home
Press F1
Thread ID: 392	1998-10-29 11:04:00	An Excel Queery? Hiding cel contents	Guest (0)	Press F1

Post ID	Timestamp	Content	User
707	1998-10-29 11:04:00	System: Pentium 133, Win 98, 80Mb RAM, I am running Excel 97 as part of the Office Pro suite. I am tutoring MS Word, Excel and PowerPoint, one on one. As part of our Course I show students how they can hide the contents of a cell with Format-cells, Choosing Custom in the Category box and entering 3 semi-colons in the Type box. I usually get the student to type their name in the cell and things work fine. At about the same point in the lesson I show how to enter the current Date and Time in a cell with Ctrl. ; space Ctrl. Shift ; (:) . When the student Hid this, the Formula Bar showed ten digits separated in the middle by a dot. When the Cell was Unhidden the figures remained. So the date and time 27/10/98 09:33 became 36095.39722. It made no difference when the date was entered manually. I understand how the computer uses numbers to figure the date. My question is, can you hide the date and the time in a cell so that it makes sense? (I can't think of a reason why you would want to. B>))	Guest (0)
1