Formatting Cells for time
i would like to enter times in the mm:ss format. however
when i select this option from the custom window, it
still converts my times into dates/times of day. how can
i correct this problem.
...Removing spaces from middle of cell
In my spreadsheet there is a column that contains number, 3 on the left,
space, 3 on the right. I want to remove that space. Rather than doing this
in three steps, taking left, then taking right, then joining those together,
is there an easier way to accomplish the same thing.
It currently looks like this 216 123
I want it to be this 216123
I'm sure there is an easier way, but I only know how in three steps.
One way is to use the formula below in a helper column and then copy the
helper column and paste special|Values back over the original data. you ca...Publisher 2003 locks up when using tables
In creating a table, the lines do not show even with correct settings.
Program also locks up when attempting to create tables or open a document
that has a table.
Do you have the service pack?
Go to the manufacturer's web site of your video adapter and look around for an
Mary Sauer MS MVP
"Farm" <Farm@discussions.microsoft.com> wrote in message
> ...Need formula in Excel to substract cell D from Cell C
Very simple question. I need the formula in Excel to substract cell D from
cell C. I have worked with Lotus but not Excel before.
Thank you. Louise
In cell E1: =C1-D1
Make sure you preface your formula with the "=" sign so that Excel "knows"
you're adding a formula, not just text...
> Very simple question. I need the formula in Excel to substract cell D from
> cell C. I have worked with Lotus but not Excel before.
> Thank you. Louise
In the cell you want the result
then click on cell in C -(minus) cell in D...Search actual Formula for cell ref?
Other than using Find from the Edit menu, is there any way of (using
formula) searching another formula for a certain cell reference?
Let's say I have a single column (B) of 100 similar formulas. I want to
check that none of the formulas contain a reference to column H, so want
a formula I can enter in the adjacent cell to flag if it does, i.e.
= IF (columnB_formula_contains_a_ref_to_column_H, "Y","")
I've been using Edit-Find to look for !H in the formulas but want to do
it using functions as can see some useful applications of the technique
(if it exist...keeping an object locked in place
Is there a way to lock objects? If they are accidentally clicked, they get
moved around. I know this is pilot error, but if there's a way lock things in
place, it would be helpful.
You can put objects on the Master Page. Ctrl+m
Mary Sauer MSFT MVP
"Paul Shotola" <PaulShotola@discussions.microsoft.com> wrote in message
> Is there a way to lock objects? If they are accidentally clicked, they get
> moved around. I know this...Money 2001 Crash, file verify on restart fails/locks
On reading the unnofficial FAQs for the newsgroup through a websearch for a
solution to my problem, it sounds like I may have no hope, but didn't
address my specific problem so I thought I'd see if anyone had a clue as to
what I should do.
Upon opening M2001 last night, it crashed and said (I believe) msmoney.exe
must shut down as it experienced a fatal error (I was only trying to open
the program) it has done it a few times before, but upon reopening the
program it will open my money file and work fine.
This time, when I reopened it told me that I had not properly closed the
file th...using hyperlinks or macro buttons to time stamp
I am currently using this code to time stamp one cell,
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If .Count > 1 Then Exit Sub
If Not Intersect(Range("A2:CL2"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy h:mm:ss"
.Value = Now
Application.EnableEvents = True
Can I do this to two cells, using a hyperlink, as in:
It is being used to track call center transact...Swap selected cell values
I am looking for a simple macro to swap the contents of two selected
cells. The cells might not be next to each other.
I know what I want it to do, but I don't know vba well enough.
If anyone has a moment to help, here is what I want to do.
Select cell1, could be A1
Control-Click additional selection of cell2, could be C1
Hot-Key Macro to:
Assign cell1 value to variable1
Assign cell2 value to variable2
Assign variable1 value to cell2
Assign variable2 value to cell1
Note: the specific cells being selected will not always be the same.
So after the macro is run the values that started ...How prevent input mask appearing in locked date field?
When user clicks in a date field that has enabled = false, locked = true,
the input mask appears even though no data can be entered. Seems like an
Access bug. How to prevent mask appearing?
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
This is no problem for me in Access 2003! When a control is set to
Enabled = False
Locked = True
Access won't let me move into the control!
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message po...Formula needed: count if cell CONTAINS certain text
What formula do I need to count the cells that CONTAIN a certain text
A1 = John
A2 = Pieter
A3 = William
count cells that CONTAIN "i": 2 (A2 and A3)
What (set of) formula should I use? Excel Help doesn't give me the
On 7 Dec 2005 04:28:36 -0800, "Wim" <firstname.lastname@example.org> wrote:
>What formula do I need to count the cells that CONTAIN a certain text
>A1 = John
>A2 = Pieter
>A3 = William
>count cells that CONTAIN "i": 2 (A2 and A3)
>What (set of) formula...How do I get the hyperlink destination cell to appear at top of sc
Hi - I want to hyperlink within the same Excel sheet. When I do, the
destination cell appears at the bottom of the screen. How do I get it to
appear at the top?
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
.ScrollRow = ActiveCell.Row
.ScrollColumn = ActiveCell.Column
This is sheet event code. Right-click on the sheet tab and "View Code".
Copy/paste the code into that module.
A click on the hyperlink will bring the destination cell to top left of
Gord Dibben MS Excel MVP
On Sun, 25 Oc...Can a cell display blank under certain conditions?
I need help with a formula...
If F3 is eqal to F2, i need F3 to display a blank cell. If F3 is not equal
to F2, I need the cell to display the sum of D2, E2, D3.
You want to change F3? That would be a macro...
> I need help with a formula...
> If F3 is eqal to F2, i need F3 to display a blank cell. If F3 is not equal
> to F2, I need the cell to display the sum of D2, E2, D3.
Uh...what you're describing is a akin to a paradox or circular logic. Assume
you have '10' in F2, then you must have '10' in F3 for it to e...locks and more locks
Hello. This is about a SQL Server 2005 back end and Access 2007 front end.
There is a front end on each user's machine. This has to do with the locking
(or blocking as some call it) issue. Connections from the front end remain
open once the user opens the front end until the front end closes, if the
user closes the front end at all and not everyone closes the front end when
done. There can be approximately 100 (+/-) people using the front end during
the day. Some may actually be transmitting data (transactions) and some may
not. But my thought is if the connection is a...outlook locking
when I open outlook it freezes and the program does not
respond. it also uses 100% cpu on my user. on the other
users it work OK. i am working with XP
...Splitting a cell
Can a column of cells be split into two equal parts with a line in the
middle? If so, how? I am using Excel 2000.
"jayfin" <email@example.com> wrote in message
> Can a column of cells be split into two equal parts with a line in the
> middle? If so, how? I am using Excel 2000.
Certainly later version have a "Text to Columns" function - not sure about
2000......SUCH a long time since I used it!!!!!
A cell itself cannot be split into parts.
The contents of a cell can be split in...How do I protect cells against only the "Delete" function?
I have a shared worksheet full of textual data (names). I want the users to
be able to freely move the data around the sheet by simple dragging movement
or through cut and paste. However, deleting any data (even if immediate
re-entering elsewhere is intended) must not be allowed in any circumstance.
Is this possible? If so, how?
Thanks for any guidance
See one suggestion at your first post.
Kev Nurse wrote:
> Hi folks,
> I have a shared worksheet full of textual data (names). I want the users to
> be able to freely move the data around t...Splitting numbers from cells and sum them
I need a FUNCTION that it will do the following:
I have cells with values from 1 to 45. I want to split the numbers i
the cells and then to sum them. The results will be of course to othe
So if i have the number 45 it will be 4+5=9
So if i have the number 10 it will be 1+0=1
So if i have the number 5 it will be 5
If i have the num 29 it will not be 2+9=11 but 2 (1+1)
i have the num 28 it will not be 2+8=10 but 1 (1+0)
Thats because i always want as result one digit number so if the firs
results isnt one digit number it has to continue the splitting !
Thanks in advanc
...How can I reference a cell in Excel to a part of a diagram in Visi
I am trying to reference a cell or a group of cells that are in MS Excel
worksheet to a specific part of a diagram which is created in MS Visio, is
this possible? If so, can anyone direct me to the reight path.
Thanks in advance.
I'd start over here
"Speedy317" <Speedy317@discussions.microsoft.com> wrote in message
> Hi folks,
> I am trying to reference a cell or a group of cells that are in MS Excel
> worksheet to a specif...Random Locked cells
I am having a problem with a spreadsheet that has random cells locked. The only way to unlock them is to copy and paste a blank cell that isn't locked into the cell that is locked, but this doesn't always work either
Has anyone had this type of problem? Any ideas
Maybe I don't understand you correct but
if you select a cell or cells and right click on it
and choose Format Cells you can change the locked
on the Protection Tab
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"Leonard Mack" <lmac...Is there a way to cut off unused cells on a sheet
It seems there are an infinite number of cells on a sheet. As I really dont
have much info to enter on each sheet I was hoping there was a way I could
somehow cut off all the extra stuff to the sides and bottoms. It is a hassle
because everytime I scroll, it will scroll off the side or bottom way past
what I was looking for.
A manual way is to goto the last used row and delete all rows below. Do the
same with columns. SAVE
"newbie" <firstname.lastname@example.org> wrote in message
news:469AABE7-8D17-4B72-91C1-...Conditional Formatting question (if cell = 0, wrap cell in quotes)
IF Cell value = 0, wrap with quotes
not exactly quotes.. but with this number format: ""'#0"',"
wrapped in single quotes, followed by a comma.
(format-cells - costum , to see what it looks like)
also, i dont want it to apply to every column (if its possible to do that)
just A1:A323, B1:B323, E1:E323, G1:G323, I1:I323, K1:K323
thanks in advance
Well, that didn't work well - the section of help that I copied was a .gif - you will need to open
the attachment.. Sorry.
MS Excel MVP
"Bernie Deitrick" <deitbe @ consumer dot...Lock a control object
I have a 'Lock' button that uses a macro to toggle specific cells in a
worksheet between protected and unprotected (allowing only unlocked cells to
be selected). I also have some combo boxes on the worksheet that I would
like to protect in the same way (ie. when locked they can't be selected). Is
YOu can use these lines of code. Since you have a toggle button you can just
set the Enable property of your comboboxes equal to the toggle button value.
Hope this helps! If so, click "YES" below.
' lock your combobox
...I want to put a hyperlink in a doc to another page in same doc
I want to put a hyperlink on a page in a power point presentation to another
page in the same presentation.
Mary Sauer MSFT MVP
"hyperlink to page in document" <hyperlink to page in
email@example.com> wrote in message
news:63...Buisness Portal 3.0: Locking error and Purchase Order Failure erro
I'm new to the company and have landed smack dab in the middle of a GP 7 to 9
upgrade. The company was using eRequisition and must implement Business
Portal and is having two errors that haven't been resolved.
#1, The selected purchase request is being modified by another user.
In order to create this issue all you have to do is open a request and close
the browser while the request is in a "being edited" (i.e. save, cancel,
approve, etc not pressed) state. Any further attempt to modify the
requisition fails withe this error. Is there any way to clear these locks?