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...comparison similar rows in Excel
How (with Excel) I could compare rows with equal contents ? For example:
row A: 1 1 1
row B: 1 0 0
row C: 1 1 1
row D: 1 0 0
row E: 0 0 0
attention: every value in row is in seperate column !
I'd like to create formula which for above exampel indicates: row A is equal
to row C, row B = row D. Row D in the above exampel hasn't similiar row.
In my work I have combination a few dozen rows and I must search out rows
with equal contents in columns. However purpose of my work is analogous to
above exampel. My work differ from the exampel number of the columns (in my
5,...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
...Inserting new rows into sheet
I am using the following code to insert a new row onto
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
This code will insert a new row above the current row number 5, which
is okay. My problem is that the new row has the same height and possibly
dimensions and formatting of row 4.
Can I basically tell Excel to insert a row of cells that are a default size
a size of my specification?? I dont want Excel to insert a row of cells
are the same dimensions of the above or below row. I realize that I co...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...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.
...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...Deleting blank rows
How can I quickly delete blank rows from a list I've
imported to an Excel worksheet so that I can after order,
filter the entire list?
Select a column which includes the blank rows. Click Edit/Go To/Special . .
Blanks - and OK. Then Right click on your selection and click Delete . . .
and select Entire Row.
Or, you could sort on a column containing the blank rows and that would put
them all together, for easy deletion.
"Joana" <email@example.com> wrote in message
> How can I quickly...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...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:
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...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
...Loop through the column and Copy entire rows where CellValue>0
I need to loop through the column and Copy entire rows where CellValue>0
I get only one row.
I will appreciate your help.
' Macro3 Macro
' Macro recorded 11/16/2004 by default
' Keyboard Shortcut: Ctrl+v
For Each Cell In Selection
If Cell.Value > 0 Then
You are probably copying each over the last paste. Try this.
For Each Cell In Selection
x=cells(row...re re re ????
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 ...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:
...How do I set end-of-range to #rows from beginning
Specifically, I am creating a chart that will have a breadth (# data points)
based on a variable (value of a cell). Start point is always the same. For
instance, a table is created based on a formula. The chart should stop when
values in the table reach a certain value, but this could be 20 or 200
datapoints (20-200 rows). I know how many datapoints should be included, but
not how to terminate the graph based on this number. I would prefer to do
this without VBA, as I am not particularly proficient, but will if the only
It would be nice to see some sample data, with a...