Replies

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 value will differ very slightly from the ‘real’ value. You don’t see this because the rounding error is smaller than the smallest value that Excel can display. In calculations, however, these differences may accumulate so that they become visible in the end result.
But I can’t explain this particular example – apparently the parentheses change the way Excel evaluates the calculation. You can get “round” it by using the ROUND function:

=ROUND(0.5-0.4-0.1,2)

this will round the stores result to 2 decimal places, whereas the number format only changes the displayed value.

Thanks Hans …. really annoying but it does explain it. Thanks for your efforts

Brilliant thanks !!

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 had something to do with word or another app in the background looping through a process so that the screen saver time out was fooled.

Thanks Hans, dont know how I missed that

Thanks so much Hans… works a treat

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 InlineShape
Dim f As Double
For Each shp In ActiveDocument.InlineShapes
f = shp.Width / shp.Height
shp.Height = InchesToPoints(2)
shp.Width = f * shp.Height
Next shp

What I need to do is put fields.unlink in somewhere. I don’t want to select the entire document because we have other fields that we need to update.

Any idea how I get it to go through each of the inline shapes and unlink them?

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 a text file with the CD Key in it.

I run a small busines with 25 computers … not big enough to have an on-site techie. All our software is licenced but before we put in place the business rule above we had to locate the “correct CD, install key” or whatever.

Copying the stuff to the local PC means that we no longer have to scratch around to find the correct install disk. Also particularly useful for the 5 laptops we run.

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

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 easily enough using the customise gantt wizard, but cant figure out how to also get the baseline costs as this doesnt appear to be an option in the drop lists.

Any help would be appreciated.

Cheers

Karen

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 55% not because I didn’t know how to do the stuff asked for but because the exam required you to use the menus in order to achieve the outcome. I was more accustomed to using shortcut keys, toolbars etc. Once I figured out how the exam worked I resat it for 100%.

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 to say it couldn’t be done if it could using native outlook functionality.

I had added the printed fields to the view but as you say they must relate to something else because all showed with no values in them.

If anyone else has any ideas I would be happy to hear them.

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 sure if it was a date field or a yes/no field, or as you say, what would be recorded if you cancelled the print.

Guess I can now go back with confidence and say that if it can be done, it would need customised forms or something to make it work.

Cheers

Karen