On Wed, 12 Sep 2007 10:15:47 +0100 Harold Fuchs wrote: > In column A I have some data. > In column B I put a formula that depends on the data in column A. > > Now If I change the data in A, the result in B also changes. How can I > prevent that happening? I'm happy with the results and I'd like to > keep them in such a way that they *can't* change regardless of what I > do to column A. > > Example. > In column A, row 1, I have, as text (*not* as a date/time), the data > "September 17, 08:30 AM". The rest of column A has similar data, all > in the same form. > I would like to have the "September 17" part in Column B and then go > back and change column A so it only contains the time part. > > So I put in column B the formula "=left(A1;12)" which correctly puts > "September 17" (leftmost 12 characters) into B1. Now I want to make > the"September 17" in B1 *text* instead of the result of a formula, so > that it no longer depends on A1. > > How? Please >
My solution would be to create column B with the dates. column C with the times then hide column A -- Michael Linux: The OS people choose without $200,000,000 of persuasion. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
