Numerical grade to Alpha characterI am trying to make a spreadsheet to keep track of my grades. I am to the
point that I have a numerical grade, but I want to add another cell to keep
track of the letter grade. I want the alpha grade to update automaticly when
I update the numerical grade.
You can use a VLookup formula to return a letter grade, based on a
number. There are instructions for VLookup in Excel's Help, and there's
an example using letter grades here:
http://www.contextures.com/xlFunctions02.html#Range
capecrusader wrote:
> I am trying to make a spreadsheet to keep track of my grades. I am t...
Allow entry of amount incl GST (tax) in Doc totalAllow entry of amount incl GST (tax) in invoice document total and calculate
backwards the net value of the document. Very important feature for
australian conditions.
--
Gino S. GPK Computers
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/B...
cell character limit11.19.09
can the character limit on an excel cell be increased? there is a standard
set up limit of 255 characters. that is too little amount. is there a way
where we can access the code that determines this limit and change it to
elimitate this problem?
please help?
thx so much
The actual limit is 32,767 characters. Of this, only 1,024 will display in a
cell.
(info from "Excel specifications and limits" in XL help file)
Due note that when you set the format of a cell to text, this is when the
256 limit kicks in. Simply change the formatting of the cell ...
in excel can not input chinese characterotherwise window anything can input chinese, but in excel can't input chinse.
why, anyone can help me?
...
Upgrade from 5.5 to 2003- Invalid Character Problem... with a twistHello everyone.
While running the prep tools I saw the error about an invalid character
(,.) in the Organization name. I figured I'd skip ahead and research
the fix in the evening. I then successfully ran /forestprep and
/domainprep.
So now I see that I just needed to change the Organization display
name. But then do I need to, or can I run /forestprep and /domainprep
again?
Many Thanks!
Eric
I would run the tests over.
John
<AntiguaRum@yahoo.com> wrote in message
news:1129731803.483490.186490@g47g2000cwa.googlegroups.com...
> Hello everyone.
>
> While running the pre...
Wrong Data Type - Too Many CharactersI have a form [FA1_OrgMaster] that has a Combo Box [cboCounties].
The cbo's Row Source is a Query with 2 columns - [TYaa_CountyNumber] -
Integer, and [TYaa_CountyName] - Text 50 characters. The first column -
CountyNumber - is Bound, but only the 2nd is displayed to the user in the cbo.
I have a Form Open Event Procedure - but it doesn't affect the cbo.
I have a Form Load Procedure that does:
_______________
Private Sub Form_Load()
On Error GoTo HandleError
Me!cboOrgs = Null
Me!cboCounties = Null
Me!cboCounties = "Choose County"
Me!cboCounties.SetF...
How do you enter Unicode characters that don't have a Alt-nnnn shortcut?I have a need to enter a range of non-English names into a combo box on a
form in an Access 2003 application. Sometimes this requires the use of
accented characters that do not appear on a UK keyboard. If I refer to the
Windows XP Character Map facility (charmap,.exe) then I can see that many
such foreign characters have been allocated an Alt-nnnn code that is
displayed at the bottom right of the Character Map acreen. This makes it
easy to enter these characters.
However, many other characters have not been given an Alt-nnnn keyboard
shortcut. They only have a U-FFFF code, displayed at...
Oracle UTF8 character set data displays incorrectly in Excel 2000 SP3Server: AIX 4.3 / Oracle 8.1.7.2.0. Enterprise Edition=20
Database
Client: Microsoft Excel 2000 (9.0.7616 SP3)
A CSV report file is generated from an Oracle Portal web=20
application. When the CSV file contains special characters=20
the CSV file displays correctly in Notepad but incorrectly=20
in Microsoft Excel.=20
We use following code to generate output in a CSV file=20
htp.p(CONVERT('WIN:WE8MSWIN1252 - Canon Espa=F1a=20
S.A.', 'WE8MSWIN1252'));=20
NOTEPAD EXCEL=20
WIN:WE8MSWIN1252 - Canon Espa=F1a S.A. WIN:WE8MSWIN1252 -=20
Canon Espa=F1 S.A....
As in GP ver7.5 allow the removal of the SQL user integrationVer 10 of GP enrypts the user password in such a way that the user can't
login using their profile to any other SQL process. Ver 7.5 allowed the
detaching of this encryption facility in GP. Removing this ability is a
backward step.
The ability to detach the GP to SQL user integration should be reinstated.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion i...
allow the entry of negative adjustments when there is Quantity onWe have a customer who wants the system to allow the processing of negative
adjustments when there is quantity on hand and negative quantity available
for a lot numbered item.
In their scenario, what they are doing is that they are entering sales order
transactions for a lot numbered item (ex. 150) when there is only 100
quantity available.
This brings the allocated to 150, quantity on hand to 100 and the quantity
available to -50.
When they decide to decrease their quantity on hand value to 50 due to some
item defects, the system is not allowing them to decrease their quantities
be...
Payroll should allow setup by assigning departments to segmentsWhen setting up payroll posting accounts for gross wages we should have the
ability to assign for e.g. departments to specific segments within the Chart
of Accounts, instead of entering all combinations. Is this possible?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane...
How does one change the alignment of characters?I'm trying to increase the font size in a word with each letter that I type.
So, for example, using my name, Craig, I would like to make the 'r' bigger
than the 'c', the 'a' bigger than the 'r', and so on to the end of the word.
BUT, I also would like to de-align the font so that the letters are centered
in relation to one another, and not all resting on the same line. Thus, the
bottom of the 'r' would be below the bottom of the 'c', not on the same line
with it, which is what happens if you just change the font size. Can thi...
remove last character in a column of part numbers if a "V"i have a column of different length part numbers and want to remove the last
letter if it is a "v" only..how do i do that?
Assuming data is in column A, put this in a helper column and copy
down.........
=IF(RIGHT(A1,1)="v",LEFT(A1,LEN(A1)-1),A1)
then Copy > PasteSpecial > Values on that helper column and then replace
your original column A with it......
Vaya con Dios,
Chuck, CABGx3
"leo" wrote:
> i have a column of different length part numbers and want to remove the last
> letter if it is a "v" only..how do i do that?
Leo,
Tr...
Excel should allow you to change custom colours more easilyDear Microsoft...
With other office products you can change the custom colours very easily,
with excel you have to go into tools, then options, then change the
colours...
Please make it as easy as the other office products.
Thanks
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the ...
Extended characters in XML to fix AccessI have an Access DB, containing car and engine specifications entered
by hand by jobbers. I use an XML file to parse the information in the
specifications. Sometime they used "extended" characters to specify
dimension or range:
Ex: 1/4 instead of 1/4
Ex: - instead of -
....etc
I need to detect and replace these characters with their ASCII
equivalent but I could not get these characters in my XML when in
UTF-8, the document loader throws and exception. How can I get these
characters in my XML ?
I am using Regex to parse and replace fragments of the jobber
description. Basicaly I...
Suddenly not able to save new or open previous files with name lengths over 45 charactersI'm using Excel 2003 if it matters ... I'm wondering if there is a
known bug/issue on this. For what ever reason, when I try to save a
new file (or for that matter open something done previously) with a
name that has more than 45 characters or so (might be off by a
couple), I get message that it can't save and then gives me a bunch of
reasons (file path might not exist, might have too many characters,
folder might be read only, etc).
I know file exists in the folder I'm checking - I can email myself the
file and open from the email so its definitely there!
Any sane insight?
...
After running a macro the first character, entered, is swallowedHello,
after running of any macro sometimes the first character, entered, is
swallowed in Word 2000 (on Windows XP SP3). Unfortunately I connot reproduce
the exact circumstances for this strange behaviour - therefore the
expression 'sometimes', but I can reproduce it on different computers.
What may be the reason for this strange behaviour;
how can this problem be resolved?
Thomas Wiedmann
We would have to see the code of the macro(s) to have any chance of helping
you. It sounds like perhaps the document does not have the focus after the
macro is run.
--
...
Looking for help with "440 Posting Not Allowed" server errorPlease help anybody . . .
I have been able to post messages via microsoft's news server but when I try
posting to those same newsgroups via titannews.com (for which I am a paying
subscriber) I always get a "440 Posting Not Allowed" server error. This
wouldn't have anything to do with needing posting privelages for the
newgroup would it? If it's a
server error then it's not even getting to the intended newsgroup? Or may
this type of error result from other causes? Maybe there's a seasoned news
server user who can point me in the right direction for resolving t...
Allow comments to be added to protected worksheet?I have created a worsksheet with selected areas locked and then protected it.
My users want to be able to add comments where necessary but are not able to.
I cant seem to find anything in the help menu - any ideas?
When protecting the sheet "allow users to:"
Select unlocked cells and Edit Objects.
Note: with edit objects checked, users can insert comments in locked cells
if they are allowed to select those.
Gord Dibben MS Excel MVP
On Wed, 4 Nov 2009 15:00:02 -0800, sue@solotel
<suesolotel@discussions.microsoft.com> wrote:
>I have created a worsksheet with sel...
Analytical Acctg should allow reporting on the item descriptionAnalytical Accounting allow you to report on the item number but only shows
the item description as a "pop up" message not a reportable field. We
invested many hours entering the description into the set up card - we want
that description in the reports that we create.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsread...
Keyboard types pipe characters after emailing PDFHello everyone,
We are using Great Plains 8 through Citrix sessions. One of our users
started experiencing strange keyboard behavior after I added an Outlook
profile to her session. This is what happens:
- Starts a GP session through Citrix
- Opens an invoice and prints to screen
- Emails the invoice as a PDF file
- Tries to open another invoice by using the Backspace key in the
document field to type a new number. At this point, the Backspace types
only the pipe character. When this happens, all keys will type pipes in
all fields until the GP session is re-initialized.
This problem seems ...
Allow source document drill down from unposted GL journal entryWhen Journal Entries are posted to the GL (instead of through), it is
sometimes necessary to drill down to the source document so that errors can
be corrected before the journal entry is posted. GP does not allow you to
drill down until the JE is posted.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "...
e-mail/ explorer will not allow attachmentsUpon switching to a new computer and running xp i recieve
the following :
AOE has removed attachments > This is everyone I get in
an e-mail
Is this fix in outlook options or in IE properties
Thanks
...
Receipt print strange characters on VistaHi All,
We run Vista business with RMS. The receipt printer is an Epson TM88 clone
and on both printers it randomly prints strange characters all over the
receipt.
It sometimes come up with an error 'unknown error - retry or cancel' but not
always.
We have never had any problems on XP so I don't know if this is Vista
related or not. The supplier of the printer suggested we download the latest
OPOS drivers which we have done without success.
Has anyone else seen or had this problem?
Thanks
Matt
...
How do I allow or disallow editingI have a form (in MS Access 2007)that is used an an input form for
updating linked tables.
I want to change the property of some text boxes on the form to be
editable based on the contents of another field.
For example; if a field contains a date (delivery date)in it, I want to
no longer allow the user to change the EquipmentName or
EquipmentQuantity fields. I want the the field to still be displayed
but no longer capable of being edited.
Is there an easy way to do this?
I prefer to do this without writing VB code, but I can if that is the
best way.
Thanks!
In the current e...