Apostrophe in Combo Box
I have a combo box which displays the employee names from a table. Users
select an entry to "reassign" a unit of work to another individual. There are
several employees with apostrophies in their name. The name appears without
the apostrophe in the combo box, so when work is reassigned, it displays the
name differently than when updated from any other process. Example: Audit
trail updates show the individual as "O'Connor" but updates using the combo
box show "OConnor".
Is there any way, without using code to load the combox, to display the
correct name...How do I insert a check mark into a cell?
Is there a way to insert a checkmark into a cell in an
Excel spreadsheet? I have not been able to find an ANSI
character code for check mark...any suggestions would be
Format the cell as Wingdings.
Then hold down the Alt key and type "0252" on the numeric
keyboard and press the Enter key.
Mark Charleston wrote:
> Is there a way to insert a checkmark into a cell in an
> Excel spreadsheet? I have not been able to find an ANSI
> character code for check mark...any suggestions would be
> greatly appreciated.
Have used Word extensively but never had the need to use the reviewing
marks. Unfortunatley I have now received a huge document back that I sent
off, with reviewing marks all over the place. I accept all the changes but
now have to somehow get rid of all the reviewing marks and format the
I can't seem to get rid of the marks. Even going to the final document,
saving, as soon as you open it again they are all back. I have read the
answers to these questions here, but I am afraid can't follow - answers seem
to go on about email options!!
Someone pl...need HELP removing box with question mark PLEASE
Hi. I exported a list of contacts from microsoft outlook as a .csv
file. In the notes section of the outlook file I have items that are
separated with a carriage return which then has notes on the next line
and next line and so on.
Well when viewing the data in excel, those carriage returns show up as
a box with a question mark.
Well I was going to use the "text to columns" command, but that won't
work with that pesky box with a question mark inside.
So unless someone has another idea, I need to replace that thing with
a comma, so then I can separate those lines into individ...Apostrophe problem
I am working with a spreadhseet and the data looks normal, however
when you click on the cell the data value contains a leading
for example the data looks like this:
IS there a quick and easy way to get rid of the leading " ' "? If
so, an advice on how to do this would be greatly appreciated!
Copy an empty cell, select the values and do edit>paste special and select
"bcap" <email@example.com> wrote in message
news:firstname.lastname@example.org....Adding Qoutation mark " to CString
I am not able to add " to my Cstring. I want a string like temp"12
CString s = "temp\"12"; this gives temp12
CString s = "temp\\"12"; - this gives compile error.
Only option is to work like this
s = "temp";
s = s + "\\";
s = s + "12";
is there any other way to put qoutation marks directly in a string?
"Anu" <email@example.com> ha scritto nel messaggio
> I am not able to add " to my Cstr...How can I place check mark
How do I place a check mark in Excel (2002)? I tried insert symbol but did
not find anything. Thanks.
If the Cell font is Wingdings2 you can use the uppercase P
Regards Ron de Bruin
"Paul T" <PaulT@discussions.microsoft.com> wrote in message news:3509A715-38A8-4DC1-9341-3E2FD95DD808@microsoft.com...
> How do I place a check mark in Excel (2002)? I tried insert symbol but did
> not find anything. Thanks.
That works. Thanks.
"Ron de Bruin" wrote:
> Hi Paul
> One way
> If the Cell font ...Apostrophe
When I try to insert an apostrophe the letter e' shows up rather than the
apostraphe ' . There is no problem here, only when typing an email in
Windows Live Mail, this has just started, have I inadvertantly hit a key?
Sounds like you might have done this
- How To Use the United States-International Keyboard Layout in Win7,
Vista and XP
Mike - http://TechHelp.Santovec.us
"A.N." <AN@discussions.microsoft.com> wrote in message
news:230B1110-E912-4031-8468-ACF10AF3FD4C@microsoft....More apostrophe nightmares
My form is driving me crazy because of stupid apostrophes in the data which the form is drawing from. I have 2 combos. cbo #1 is
populated by project names.
(The control is also named "Project Name" while the cbo #2 is named "Tenant" and is populated by tenant names from the tenant field
in the table. I know this is bad form, so to speak, but lets please ignore that today. I didn't create the form or the control and I
have limited time so I have to pick my battles).
When I select a project in the first cbo "Project Name", the goal is to have the tenant cb...Re: foreign language accent marks
On Sat, 12 Jun 2010 11:10:45 -0400, Jeff Zeitlin
>On Sat, 12 Jun 2010 08:13:49 +0100, Dominic Payer <firstname.lastname@example.org>
>>Find Character Map in your Windows Accessories/Tools menu and note and
>>remember the Alt+numeric sequence for the accented characters you need
>>in the fonts you use.
>>The numbers in the sequences must be entered on the right hand numeric
>>keypad not the numeric keys above the keyboard letters.
>This is not going to always be possi...Marking spam
I have just reinstalled Outlook 2007 and activated spam filters, set
Now I am finding that much of my email--some of it not spam--is marked
SPAM. This wasn't happening before. How do I shut it off?
Do you mean the word SPAM is actually in the subject or elsewhere in the
mail item? If so, that's another program or your providers server doing
"jmparsons3" <email@example.com> wrote in message
> I have just reinstalled Outlook 2007 and activated spam ...email address format
I ran into a problem that I cannot find documentation for. I created a
distribution list in the format !firstname.lastname@example.org
I realized that Exchange 2003 would not accept internet email to that
address when the exclamation mark is the first character in the email
address. Can someone confirm that is the case or some weird bug?
How do you remove the apostrophe in a cell? I have numbers and text imported
from another program.
Dim rCell As Range
Dim Rng As Range
Set Rng = ActiveSheet.UsedRange '<<=== CHANGE
For Each rCell In Rng
If rCell.PrefixCharacter = "'" Then
rCell.Value = rCell.Value
If you do not wish the procedure to operate on the whole sheet. you should
set Rng to an appropriately restricted range.
"Dana" <Dana@discussio...Apostrophe Problem
I use a control on a form which I have concatenated from the users First and
last names. All works well if I select, Harry Smith, but when I select a name
with an apostrophe in it, Kelly O'Malley, I get a run time error 3077. The
Private Sub Combo80_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Name] = '" & Me![Combo80] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Add this to a standard ...how do I insert tally marks in an office document?
I am trying to insert a tally chart in an office document.Any suggestion.
Are you trying to create a fill-in form? Or simply a manual check-off?
If it is the former:
Create a Fill-in Form in Word
Lots of images here for tally charts, it might give you an idea on how to
"STARR" <STARR@discussions.microsoft.co...Change/mark duplicate entries in account as similar.
I have a credit card account, and checking account. I end up with:
Credit card account: -100 dollars
I pay my credit card bill with the checking account:
Checking -100 dollars
I mark it as a Transfer from Checking TO Credit Card. The credit card
account now ends up with 2 duplicate entries:
I click on the "Change" button, and mark them as identical and everything
But if I happend to already mark both entries, I can not go back and change
them to identical. I can not find this option when I already categorized an
entry! I end up with duplic...apostrophes
I have a formula with an apostrophe, but it's not a leading apostrophe.
I wrote it this way for reasons I won't bore you with, but there is a good
reason. The idea is that a particular moment I can take out the apostrophe
using find/replace and thus activate the formula.
I know removing the apostrophe by using find/replace doesn't work on leading
apostrophes, but it does work on non-leading apostrophes in some
circumstances. Does anyone know what those criteria are? On some
spreadsheets it works, on others it doesn't.
If they are like your exa...Revision marking greyed out
Revision marking is on. All changes are greyed out so I can not accept or
reject any changes.
Is the document protected? You might try unprotecting it.
"Ken W" wrote:
> Revision marking is on. All changes are greyed out so I can not accept or
> reject any changes.
It's not protected.
> Is the document protected? You might try unprotecting it.
> "Ken W" wrote:
> > Revision marking is on. All changes are greyed out so I can not accept or
> > reject any changes.
...Apostrophe in search string
I have a simple SQL string that is run from a form when a field is updated:
strSQL = "UPDATE tblDesign " & _
"SET " & strFieldNameForUpdate & " = '" & strDM & "' " & _
"WHERE DesignName = '" & strName & "' ;"
It works fine except for where there is (rarely) an apostrophe in the
strName field data. I cannot work out how many extra quotes to put into the
sql build string to get round this.
A debug.print of the string that causes a syntax problem is:
UPDATE tblDesign S...apostrophe
Hi all, I just received an excel workbook where all the numbers have
been typed with an apostrophe ' in front of them, therefore no
formulas work, i.e., the worksheet does not view them as numbers.
Going in to each cell and removing the apostrophe works, but the table
is way to big to do that for every cell. I tried find/replace, but it
doesn't find the apostrophe's. I also tried reformatting the columns,
copying and using the various forms of "paste special", etc., and have
yet to find anything that works.
=A1*1 will reve...removing leading ' (apostrophe)
I have been given a spreadsheet by another department that was exported
form another package. The problem I have is that all the data in
every cell has a leading ' (apostrophe). For example, when you look at
the contents of the cell that displays as 12/31/2003, it shows
'12/31/2003. I've tried to format the cells, but that doesn't work.
Is there any easy way to remove the leading character for the whole
column or sheet? Thanks in advance for help.
Message posted from http://www.ExcelForum.com/
"...how to place a "check mark" in a column
I need to show whether or not an employee has completed a
program. I would like to use an x for no and a "check
mark" for yes. Is there anyway to do this? Thanks for
Check this previous post for a starter
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Lisa" <email@example.com> wrote in message
> I need to show whether or not an employee has completed a
> program. ...Marking all lines with same value when a second value is found
I have a excel 2003 spreadsheet with a list containing order number, date,
status. I want to create a function to give a value in a new field for all
order numbers if one of the statuses is 'on hold'
My data would be like below
Order# Date Status
1 7/1/2005 Received
1 7/2/2005 Closed
2 7/1/2005 Received
2 7/2/2005 On Hold
2 7/5/2005 Closed
In the new field I would like all that lines for order 2 to have a "Yes"
value in the new field because one of the status was On Hold
say your data is in th...More apostrophes!!
The following causes errors on my forms when the record contains an
Private Sub Combo2_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ownername] = '" & Me![Combo2] & "'"
Me.Bookmark = rs.Bookmark
what changes do i need to make?
Will your data contain double quotation marks? If not, try:
rs.FindFirst "[ownername] = """ & Me![Combo2] & """"
Anthony Speiser wrote:
>The followi...Peculiar apostrophes...
Just a quick one ( I think),
Pointed at a page in the (UK) Times, I use the 'File/Send To/Mail Recipient'
sequence to pass it on, and the subject line comes out:
Prince Charles blames world�?Ts ills on �?~soulless consumerism�?T and
Galileo - Times Online
With the article's title apostrophes replaced.
It happens with either of OE or Outlook as the default.
Is this likely to be a fault at my end, or is it in the newspaper's site?
Check your settings in IE (yes, IE) View | Encoding.
> Just a quick one ( I think),