Re: cl-quiz ...Transpose the 2 and colon....#'format doesn't seem to be ... smart enough to talk about puppies or children. ... (comp.lang.lisp)
Re: HELP replacing cell references in equations with $X$Y format ... First of all, if you are using Excel 2007, it has a new transpose function... I never heard anything suggesting that the references had to be in ... I'm assuming you mean $A$1 format as I've never ... (microsoft.public.excel.programming)
Re: Format$() Function ... Replace to change the decimal to a colon ... ... That will work except that I get a period separator versus a colon. ... If I try: using a colon in the Format function I get the formatting wrong, i.e. 42 is: in the seconds versus minutes. ... (microsoft.public.vb.general.discussion)
Re: memory card formatter ?? ... out the colon. ... So when i do it in WinXP,... > format from within the mp3 player. ... (microsoft.public.windowsxp.help_and_support)
Re: is there a quick easy way to input time? ... Click on Tools | Autocorrect and in the Replace box enter a full-stop ... and in the With box enter a colon, then click Add and then OK to close ...format may not show the seconds, but you change that by Format | Cells ... How is military time input into a spreadsheet? ... (microsoft.public.excel.worksheet.functions)