That sounds rather sad (but I know what you mean).
[edit: Very satisfying when you work out things like your own little "perpetual calender" macro in Excel to tell you, exactly, how many hours an experiment has been running if you enter the start and finish time/dates - and then hide it behind a "GO" button for others to use. I tried to start an intranet page to publish such things, but without much success in that company.] _________________ Reality is that which, when you stop believing in it, doesn't go away. - Phillip K. Dick
Location: Walking the narrow path, singing merrily and living Victoriously
Posted: Sat Mar 20, 2010 1:09 am Post subject:
You need to format the cell - either by right clicking, or by going to Format at the top - then select cell.
You want the first tab - Number, then in the dialogue box go down to number. That gives you the option to turn the number in the cell to always positive (or vice versa).
I like Exel
You're a little star!! Thank you. As soon as I read your destructions, I realised I already knew the answer.
I like Excel too.
_________________ <><Although Christians and Mormons use the same words such as grace, faith, God and sin, they mean very different things by them. Beware the poison!><>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum