How to stop excel replaceing numbers with the date?
One way is to precede the entry with an apostrophe (').
If it is fractions, try preceding with 0 and then a space before the
"Jamescowles" <Jamescowles@discussions.microsoft.com> wrote in message
Sorry for newbie question...
I want the top of my columns to be titles for my columns eg January,
February etc then to have a space (eg a blank row) before the data entry
begins. Excel is calling my titles as row 1, my blank space as row 2 and then
my first line of data row 3. Can I tell it that the titles and blank space
should not be counted as rows so that the first data is labeled as row 1 and
not row 3?
Excel's rows are numbered from the top row.
You cannot change this numbering system.
Row 3 is row 3 no matter what you place in rows 1 and 2
You w...Storing Credit Card Inormation
I am on the prowl for a well designed addon for RMS 2.0 that allows the users
to store their customer's credit card information so they are able to
recharge their customers credit cards on a monthey basis or whenever they
need to depending on the business.
does any body know of a PCI Compliant addon that will allow for this? This
seems to be a tool that customer's regularly ask me about and I sadly have to
tell them that it is not available. Please advice me if you know differnent.
Thanks in advance.
We are in the final stages of testing such a tool. If yo...removing dashes from phone numbers
i have a column of phones numbers with the format 555-111-2222 and I want to
remove the dashes so that they are 5551112222 so that I can use a vertical
lookup. What's the easiest way to do this?
> i have a column of phones numbers with the format 555-111-2222 and I want to
> remove the dashes so that they are 5551112222 so that I can use a vertical
> lookup. What's the easiest way to do this?
You can use Edit Find to open the find/replace window.
Then find - and replace with no...Re-arranging table using pivot-table?
I have a worksheet with data organized somewhat like this:
New York New York
New York Albany
California Los Angeles
California San Diego
I need to convert this to a list of states and each city in the columns to
the right of their corresponding state. Something like this:
New York New York Albany
Florida Miami Orlando Tampa
California Los Angeles San Diego
Any help is greatly appreci...Re-install Outlook 2002
I am trying to re-install Outlook 2002 for my palm pilot
after a crash. The installation will run until I get the
message - "another version is already installed and must
be uninstalled". The previous version was corrupt and I
was unable to uninstall it. Now when I go into the control
panel to add/remove the uninstall is no longer in the
...change scientific format of numbers
I'm trying to publish a paper to a scientific journal
including graphs generated with Excel XP. When a log
scale is used the journal format requires the scientific
format of the axis numbers to be like 10^n (10
superscript the exponent number) rather than 1E+n as it
is standard in Excel.
Is there an easy way to change that format?
There is no way to do this with axis number - one of the weakness of Excel
for scientific use.
I expect you could fake it by using labels. How many graphs do you have?
remove CAPS in e-mail...Create Batch file for laptops to copy templates
I am new to batch file programming and need an expert help to find out
something. I want to create a batch file that runs at login and compares a
local copy of the templates to what we have on the network. We have templates
on a mapped network drive in h:\clients\templates, and on the laptop in
c:\apps\data\clients\templates. When the laptop is offline it substitutes
c:\apps\data to appear as h: drive, that way the files appear to be in
h:\clients\templates. Here’s the basic steps what I need the batch file for:
1. first it checks to see if the computer is on th...Re-Enable CRM User
I am trying to enable a disabled CRM user and I received the following error
message. Any thoughts or suggestions would be greatly appreciated.
String UserId) +0
Microsoft.Crm.Application.Platform.SystemUser.Activate(String id) +38
sender, DataEventArgs e) +127
eventId, FormState state, User user, String objectId,...RE:Excel will not open from a web link
When opening a link on a web page that has an Excel
Spreadsheet embedded in it, the spreadsheet will not open
up Excel but opens within another browser as an Excel
file. Programming on webpage is correct, opens up on
other machines just fine.
...Use Tax & the Credit Card method
I'm looking for some input on how people are managing their "Use Tax" in
Great Plains with out the use of a 3rd party vendor. I've found some info on
the "Credit Card" method of managing sales & Use tax (see below) and would
appreciate any input on that or if anyone has other suggestions on how they
are managing their "Use Tax" any info would be appreciated.
Create a special "Credit Card" for the tax man. Now enter the payables
> vouchers and allow the use tax due to be calculated and added to the voucher.
> Before saving the...Adding up negative numbers only
Ok, let me try to explain this problem. I have several cells a1 throug
a10. Each cell has a number, for ex. $10.00, ($5.00),etc. , sometime
this number is positive, sometimes it is negative. I want to only ad
all of the negative numbers in cells a1:a10 and put a total in cel
a11. How can I do this?
tonydepo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1530
View this thread: http://www.excelforum.com/showthread.php?threadid=26928
=SUMIF(A1:A10,"<0&quo...convert letters to numbers
Whats the quickest way to convert letters to numbers, a = 1, b = 2, c =
3, .....z = 26.
i.e. the cat sat on ............
would look like
20,8,5, 3,1,20, 19,1,20, 15,14,
so my child can convert "secret codes" with her friends.
Prefer the numbers to be displayed above the letter.
I can only think of excel to do this is this possible with Word?
Thanks in advance
You can do it either in Excel or word. Getting the letter values is
relatively easy using a for next loop, mid and asc functions. more
difficult is the l...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Re: exmerge error
I am getting the following error when trying to use exmerg
can anyone please help
Microsoft Exchange Mailbox Merge Program, v4.00.02
Start Logging:February 27, 2004 20:04:3
[20:04:31] Logging Level: Non
[20:04:31] Reading settings from file 'C:\Program Files\Exchsrvr\BIN\EXMERGE.INI'
[20:04:32] Error 8007203a opening an LDAP connection. ('LDAP://EXCHANGE/rootDSE') (CADRoutines::GetNamingContextData
[20:04:32] Accessing Domain Controller 'PROFI...Ron Bovey re: "Trim Selection" in ExcelUtilities
Cells in my Excel spreadsheet appear to be empty. However, when I use
Edit/Go To/Special/Blanks, I get "No cells were found".
In the past, Ron Bovey suggested going to the WWW.APPROS.COM website,
download ExcelUtilities and then use the "Trim Selection" utility to
remove the characters that are making the cells not empty.
Since then, I've gone to the WWW.APPROS.COM website and downloaded the
ASAP Utilities. However, I can seem to find the "Trim Selection" nor
any utility that will do the same thing.
Try going to Rob (not Ron) Bovey's site:
...shorten a number
How can I abbreviate a number from, for instance 6 figures, to 2 figures
behind the comma
Thanks in advance
> How can I abbreviate a number from, for instance 6 figures, to 2 figures
> behind the comma
I use Office 2002 with Windows 2000 and I would like to use the format
(500.00) when it is negative instead of the minus sign when writing numbers
I do not have that option in the format cell, how come?
My friend is using the same Office 2002 with Windows 2000 and she does have
the brakets in her format.
We both have the same Service Pack for Office and Windows.
she can simply enter the same format as custom format. she probably has
different regional settings
> I use Office ...Continuous Numbering
This is a multi-part message in MIME format.
How does one invoke continuous numbering when there has been a break and =
the numbering starts over again? Word has a drop down menu for this, =
but I can't figure out how to do so in Publisher.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Tr...re re re ????
...calling Batch ID lookup in Payroll
I would like to know how to call UPR_Batch_ID_Lookup in payroll madule.
Thanks in advance..
Thanks & regards
You would need to do the ff.
1. Use the "open form <FormName> return to <ReturnField>"
2. Optional. Set the 'Batch ID' of window UPR_Batch_ID_Lookup to the current
return field value if you want the lookup to show
3. Set the 'UPR Batch Origin' of window UPR_Batch_ID_Lookup to either
computer or manual (1 or 2)
4. Run the 'Redisplay Button' of window UPR_Batch_ID_Lookup
Hope this helps.
This posting is...How do I get invisible lines & borders to re-appear?
In Publisher 2003, table grid lines, text box borders and autoshape borders
have become invisible on-screen, although they do print out. Any ideas on how
to remedy this?
Recently installed Adobe PDF Maker which seems to have precipitated this,
although it could be entirely co-incidental.
Try updating your video drivers.
MVP Microsoft [Publisher]
"Ackerman & Co" <Ackerman & Co@discussions.microsoft.com> wrote in message
> In Publisher 2003, table grid lines, text box borders and auto...Re:
...Re: Where should be the best place to stored Applcation Data Files?
"Giovanni Dicanio" <gdicanio@_NOSPAM_email_DOT_it> ha scritto nel messaggio
> BTW: this post by John Robbins is very interesting reading:
copy-and-pasto - the correct link is this:
And then there's this Vista security discussion from last Friday (cool
On Fri, 8 Aug 2008 18:50:23 +0200, ...Re-enter payee information
I have been using MS Money to pay bills and frequent
annoyance is when I type in the payee, the selection list
never shows the payees. I type it in and have to re-
enter the account number and everything. Doesn't make
sense that i have to keep putting this in. Anyone know
what I am doing wrong? I've checked these boards and
found help with my passport problem but no entries on
Money has two kinds of Payees. Explicit--those on the explicit list that
shows in Accounts & Bills|Categories & Payees|Payees--and implicit--those
that are recorded somewhere in a tra...