Does Word or Excel have a calculator?

[Guest]

How to obtain a calculator in Word or Excel?

 

[Gord Dibben]

Why not use the Calculator that comes with Windows?

Start>Run "calc.exe"(no quotes).

If you want to have the calculator called from a Toolbar Button in Word or
Excel, copy and paste this macro to a General Module in Your Personal.xls in
Excel.

Copy/paste to a General Module in Normal.dot in Word.

Sub Calculator()
Dim taskID As Variant
On Error Resume Next
taskID = Shell("start calc.exe")
If Err <> 0 Then _
MsgBox "CALC.EXE is not installed on your machine."
End Sub

If not familiar with Macros see David McRitchie's "getting started" pages.

Gord Dibben Excel MVP

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Myrna Larson]

You are expected to use the Windows' calculator. You should find it at Start
Menu/All Programs/Accessories

 

[Debra Dalgleish]

In addition to the suggestions by Gord and Myrna, if you have a fairly
new keyboard, it may have a Calculator button.
(look for round buttons above the number keypad, or at the top of the
keyboard)

 

[Gord Dibben]

Forgot about that one Deb.

My MS Multi-Media keyboard has the calculator button along with gaggle of
others.

First thing I did was to disable the default F-Lock feature<g>

Gord

 

[Dave Peterson]

You could even add an icon to your favorite toolbar:

Tools|Customize|commands tab|Tools Category.

Scroll down until you see Custom and look for an icon that looks like a
calculator.

Drag it to your favorite toolbar.

 

[Myrna Larson]

Mine does, too, but turning on F-lock doesn't disable the dedicated Calculator
button over near the right end.

 

[Dana DeLouis]

Hi Dave. I had the Calculator icon with Excel XP, but I don't have it with
Excel 2003. I couldn't find it anywhere. Does anyone else have it? Is it
just me, or did Microsoft remove this in the 2003 version? Just curious,
that's all.

 

[JulieD]

Hi Dana

i think its still there - view / toolbars / customize / commands - tools
section - scroll down and you'll find the word "custom" next to a caclulator
icon - drag to toolbar .... when pressed it displays the windows calculator.

Cheers
JulieD

Hi Dave. I had the Calculator icon with Excel XP, but I don't have it
with Excel 2003. I couldn't find it anywhere. Does anyone else have it?
Is it just me, or did Microsoft remove this in the 2003 version? Just
curious, that's all.

 

[Earl Kiosterud]

Me,

Also, in Excel, you can get an ad hoc calculator of sorts by selecting
cells, and looking at the Status Bar toward the right. You'll see something
like "Sum=123." Right click it to change the function from SUM to something
else, like Average, Count, etc.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net

For a video that will certainly make you smile,
http://www.smokeylake.com/snbrussels.mpg. It's about an expectant father
who gets on a plane, and the airline staff. About 3 meg.

 

[Dana DeLouis]

Ahh. There it is! Thanks Julie (and Dave). Don't know how I kept missing
it. I think I must have been looking at the first calculator icon that is
assigned to "Calculate Now." Must be time for glasses. :>(

--
Dana DeLouis
Win XP & Office 2003

Hi Dana

i think its still there - view / toolbars / customize / commands - tools
section - scroll down and you'll find the word "custom" next to a
caclulator icon - drag to toolbar .... when pressed it displays the
windows calculator.

Cheers
JulieD

 

[Myrna Larson]

Some days are like that <g>. For me, they seem to be getting more and more
frequent

 

[Dave Peterson]

I just start a new workbook (or insert a new sheet).

Then I can type my entries in individual cells and correct/change them when I
want. And (for my purposes), excel does an ok job calculating <bg>.