Search:

It must be some kind of rounding error. Excel stores numbers in binary format (existing exclusively of 0s and 1s). Most decimal numbers cannot be represented exactly in binary format, so the stored...

0.5 - 0.4 - 0.1 equals 0 right?

If you put that in Excel as purely "=0.5-0.4-0.1" it gets this correct.

Can you then explain to me WHY "=(0.5-0.4-0.1)" returns the answer "-2.77556E-17"


If...

Brilliant thanks !!

Hi,

I know there is a formula for this but I can't for the life of me remember it or its name. I import data into a worksheet. I want to put a forumula in another worksheet which will countif .......

Thanks for your reply Hanse. Unfortunately installing an add-in is not an option. I seem to remember seeing a work around at some time, but cant for the life of me remember what it was. I think it...

Hi,

Does anyone know how you can stop the screen saver kicking in while in slide show mode. Security settings are such that I cannot change settings in the control panel.

Cheers

Thanks Hans, dont know how I missed that

Hi

I have recently purchased this product but can't work out how to get the number of pages to print in the footer (eg Page 1 of XX Pages). If you are unable to help does anyone know of any...

Thanks so much Hans... works a treat <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Thanks - that helps a lot brought it down from 10 meg to 1. What I would now like to do is try to do this with code. With the help of this board the following code resizes the images

Dim shp As...

Really not sure which forum to post this on ... Word, Powerpoint or VBA

The problem is this..... we regularly compile a number of presentations into a booklet. They are laid out three to a page...

Rule Number 1 ... before installing any program copy the entire cd or set of installation files to another partition, drive or folder on your hard drive, also to a folder on a network drive - create...

Hi all,

I was wondering if anyone could help. We want to start generating a newsletter but it is critical that these only go to people who have asked for them to be sent. It is also critical that...

Thanks Jerry ... not that one is not quite what I want but it looks like jefferson has helped me out. Thank you for your response anyway.

Cheers

Thanks Jefferson, I will have a go incorporating it into front page and will let you know how it goes

Yes that is the sort of thing I am looking for. Unfortunately the answer isn't quite step by step enough for me as a newbie

I want to create something on my site so that when a word is clicked on the text expands, similar to what is seen in a lot of online help and exactly the sort of thing that shows in the attachment.
...

Do you know how I can get baseline costs to appear on a gantt chart, basically I would like to see baseline costs on the left of the bar and actual costs on the right.

I can get the actual costs...

Can anyone recommend any forums devoted to analysing the Office 2007 suite. We are a training firm looking at the beta version of office and would like to discuss features, drawbacks and workargounds...

Thanks for that Candi ... I might just do them again ... cheers

I haven't done my MOS exams for a number of years, but it is defeniately worth the money for a practice exam so you understand the expected responses. The first time I sat the Excel exam I got about...

Thanks both for your input ... as I thought ... might be possible with a customised form and outlook coding, but as this is in a corporate environment, I don't think that will fly. Just didn't want...

Hmmm, thanks for your input ... someone mentioned this to me (I am a computer trainer) and swears they have seen it on a users machine .... I can't figure out how it might be done... I am also not...

Hi,

Is there any way of customising my inbox fields to show if an email has been printed. I have looked in the field chooser but cant seem to find anything.

Cheers

This is no real help but I have seen the same thing a number of times when converting to 2003. It does seem though, that you only have to point to the new data file once, and from there on in it...