Does Word or Excel have a calculator?

  • Thread starter Me, me, me, me, meeeeeeeee
  • Start date
G

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
 
M

Myrna Larson

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

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)
 
G

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
 
D

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.
 
M

Myrna Larson

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

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.
 
J

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


Dana DeLouis said:
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.
 
E

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.
 
D

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


JulieD said:
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
 
M

Myrna Larson

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

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>.
 
Top