|
|
"Replace With" option by
Joey
Hi all
I would like to amend a column with phone numbers and change only the
first two characters to a "0"
Most of the numbers look like this;
44131 555...
|
|
2 |
156 |
|
|
|
|
1 |
186 |
|
|
|
|
1 |
158 |
|
|
"Runtime Error: Subscript Out of Range" by
bludovico
What the heck does this mean? If you hadn't guessed, I'm new to macros.
I'm getting this message when I try to run one of mine. THe macro opens
another...
|
|
1 |
268 |
|
|
|
|
1 |
88 |
|
|
"Save changes" question. by
Paul
Why do I get a message asking me if I want to save the
changes made to the spreadsheet when I didn't do a thing
to it? I merely opened it up, looked at data...
|
|
1 |
196 |
|
|
|
August 19th, 2005 05:46 AM
by Frances
|
3 |
154 |
|
|
|
|
7 |
249 |
|
|
"Show All" in Excel by
PokerPaul
Is there a "Show All" or something similar in Excel like there is in Word? I
am having trouble with hidden text (spaces) in the "COUNTA" function.
|
|
1 |
88 |
|
|
"solver" by
tb
need to add in solver, but no longer have cd. any suggestions on how I can
add this feature without a cd?
|
|
1 |
81 |
|
|
|
|
4 |
200 |
|
|
"Sum of" in column heading in pivot table by
Gary Rowe
When I move a column titled January into a column area of a pivottable the
title says "sum of January". I cannot change it to "January" without an
error...
|
|
1 |
133 |
|
|
"Super Excel" by
Arnab Bose
I don't think Excel actually stores all the cell
properties in a huge 256x65536 array... otherwise it would
take a looot of time to execute some of the...
|
July 14th, 2004 07:28 PM
by hgrove
|
2 |
299 |
|
|
"to many line continuation" by
an
Hello!
To prevent the message:
"to many line continuation"
Is possible to change next:
If = "XXX" Then
.Visible = False
.Visible = False
|
|
1 |
105 |
|
|
|
|
1 |
122 |
|
|
|
|
1 |
241 |
|
|
"Transmitting" results by
Prospero
Is there a way to write a formula that "sends" its result to another
cell.
For example:
Cell A1 contains a balance, £50
Cell B1 contains a deposit, £50
Cell...
|
|
1 |
93 |
|
|
|
|
2 |
101 |
|
|
"unexpected file lock by . " error by
MCM1009
I have an excel spreadsheet that is shared and accessed by 5 computers. Only
one person at a time can make changes. However, periodically I am getting...
|
August 25th, 2005 12:12 AM
by MCM1009
|
0 |
100 |
|
|
"update link" image distorted by
luisp
ok, so I do a "edit\special paste\paste link\Microsoft
excel Worksheet object" from a XLS spread sheet onto a
PPT page and the image (that gets paste) comes...
|
August 10th, 2004 05:23 PM
by luisp
|
0 |
461 |