Search:

Thanks for trying, but the sites you referred me to were to freeze panes, what I am trying to achieve is freezing data after the event.

I have formula that reads a cell if another cell equals today. Is there any way that this data can automatically frozen, so that the data remains when I open up the spreadsheet tomorrow.

Example: ...

Thanks for your efforts, but one of your suggestions is text to columns, but this doesnt recognise the difference between letters and numbers. The other suggestion, I could not find a route for the...

I have a column with a combination of numbers and letters ( numbers always first ), eg

Column A

100M
10N
1U
21LR

Text to columns does not work, all I wish to do is seperate the numbers...

My project starts on the 5th january 2009, using our own calendar, therfore day 1 is the 5th jan, and to use a base line, day 75 should be 22nd april 2009. I have customised the 'duration10' field,...

Thanks for the response, I think I may have confused us both.
My project starts on the 5th january 2009, using our own calendar, therfore day 1 is the 5th jan, and to use a base line, day 75 should...

I have set up a project, containing a number field, which relates to the day that I would like work to start on, i.e. job 1 starts on day 1, job 2 starts on day 5 etc. Is there a formula that will...