|
Commas and periodes
Hi...
I want copy a lot of numbers from an english list into Excel.
Problem is that english uses . (periode) as a decimal divider, instead of a
, (comma) as we do here in Norway.
The thing is that Excel automatically change the properties of these cells
to DATE and 1.75 becomes jan.75
I want it to read 1,75 (with a comma) as a number and not a date.
Is there a solution to this?
P...
|
7 |
10/24/2008 8:59:31 PM |
|
|
nVidia nView in Excel
I have a user that has been upgraded to O2007 from O2003. Previously he was
able to use the next display functions, with the update this feature has been
disabled. Any ideas?...
|
3 |
10/24/2008 8:43:01 PM |
|
|
Macro for 'Paste Special'
Is there a way to set a macro up so that perform a 'paste special'
into whatever cell is currently highlited?
Thanks in advance....
|
4 |
10/24/2008 8:33:11 PM |
|
|
Sahring microsoft office excel documents in sharepoint in edit mod
> Can users share the same document in 'edit in microsoft office excel'
> allowing both the edit the same document, if so where do I set access
--
GJEmberson...
|
2 |
10/24/2008 8:31:01 PM |
|
|
Conditional formatting
I want to change font when a cell takes a certain value from a formula, but
in the conditional formatting box the font selection is ghosted out. Any tips
on how I can do this?
--
Shamus...
|
2 |
10/24/2008 8:28:05 PM |
|
|
Concatenating Two Columns
I need to concatenate an entire column of first names and a matching
column of last names into a new column of first name:" ":last name.
Can I use the "CONCATENATE" command once to accomplish this? If so,
what is the exact syntax I should use and in what cell should I put
the command?...
|
4 |
10/24/2008 8:14:23 PM |
|
|
Add Duplicates
I am trying to add the quantity from column B if column A is a
duplicate. I have thousands of rows and any help would be
appreciated.
A B
Text 1
Text 1
Thanks!...
|
4 |
10/24/2008 7:56:01 PM |
|
|
Coping from one spreadsheet to another - but loses text formatting and replaces blanks with 0
Hi,
The subject says it all! I've got a 'master' spreadsheet with several
tabs of basic data and I would like 'slave' spreadsheets which are
automatically updated when I change the master.
I'm fine (or so I thought...) with coping from one spreadsheet to
another in a different file altogether - but then I lose all text
formatting and blank cells are replaced with 0.
Could anyone offe...
|
4 |
10/24/2008 6:03:48 PM |
|
|
Need formula to calculate List Price.
Need help with an excel formula to figure out the list price. I was
given the discount (%) and my net price but I want to figure out what
was the origin list price before the discount was applied.
I have following cells which have the data I need to look at to get
final cost.
A10 - Contains the net price (my price)
B10 - Contains my discount (%)
C10 - Where I want the list price to appear...
|
4 |
10/24/2008 2:24:11 PM |
|
|
I've inharited a spreadsheet that I need to change the query to an external source...
I've inharited a spreadsheet that connects to an external source, our SQL
2005 server.
I've altered the query to reflect our server name and saved it in Excel as a
query with a new name.
If I press F5 I can select the range, then I click on the Edit Query icon .
First it says "This query cannot be edited by the Query Wizard", I press OK.
Then it says "Invalid object name "TheirSERVERNAME.o...
|
3 |
10/24/2008 12:57:51 PM |
|
|
Text to Columns
Anyone out there suggest a way of splitting names. i.e
Mr Anthony Lee Rodgers
Mr John Edward Rourke
Mr Ian Ruff
Mr Ian Sanderson
I am looking to get the following end result.
Title 1st Name(s) Last Name
Mr Anthony Lee Rodgers
Mr John Edward Rourke
Mr Ian Ruff
Mr Ian Sanderson
Regards
...
|
4 |
10/24/2008 9:07:45 AM |
|
|
Excel Pivot table calculated field
Hi
i have a list of share prices and dates - i have used a pivot table to
show me the maximum share price for that share - i need help in trying
to calcualte the date on which this share price occured - can anyone
help.
columns in excel are
Stock name, date, share price, volume
regards
simon...
|
5 |
10/24/2008 8:45:37 AM |
|
|
Applying defined names to existing formulas
tried to use the ‘name’ feature of excel – for named ranges to appear
in formulas instead of cell references?
Eg =licence_costs to appear as the formula instead of =C21
I have selected the source cell C21 in Sheet1 and created a name
licence_cost. I can see the name defined in the menu option Insert/
Name. Refers to =Sheet1!$C$21 (I note an absolute reference is
created automatically...
|
4 |
10/24/2008 7:12:09 AM |
|
|
What's the best Excel 2007 Hardware?
Hi,
I have to buy a new computer and I'm looking for the fastest solution
for Excel 2007. I'm working every day with Excel and I have to wait
often until the program finish a operation. Mostly I work with
Pivot-Tables based on a big amount of data (50 columns * 500000 rows).
I would like to make Pivot operations faster. (yes, it depends on the
PT-Design ... )
I would like to by a 4 GB / C...
|
5 |
10/24/2008 3:51:01 AM |
|
|
Using Named Range in LOOKUP formula?
My LOOKUP formula currently reads:
=((LOOKUP($I6,$A$2:$A$7,$D$2:$D$7)-J6)+(LOOKUP($I6,$A$2:$A$7,$G$2:$G
$7)))
I would like to change this so the ranges are columns in a Named
Range. Something like:
=((LOOKUP($I6,Range_Col1,Range_Col4)-J6)+
(LOOKUP($I6,Range_Col1,Range_Col7)))
The range name will be selected in a drop-down (data validation) in
another cell. So "Range_Col1" actually ne...
|
5 |
10/24/2008 3:06:01 AM |
|
|
Status Bar disappears in Excel 2007
I get this problem repeatedly and it's very, very annoying. The Status Bar
keeps disappearing in Excel and the only solution seems to be to close and
keep reopening the application.
This is very annoying as I'm using an add-in that takes about 30 seconds to
load.
I tried to Google this, but seems like no one's reported a similar problem
before. Can someone tell me where I can access ...
|
2 |
10/24/2008 2:34:01 AM |
|
|
Where to learn more about Excel
I know the basics but I really want to learn more about how it works. Can
someone direct me to an online site or book that is easy to understand and
explains things step by step?
Thanks,...
|
3 |
10/24/2008 2:13:14 AM |
|
|
Excel 2003 - VBA - Toolbar Control
I now create floating toolbars at the drop of a hat. In fact, I'm soooo good
at it that at times I may have two or three just sitting there. This is not
what I intended.
In a minimalist nutshell, this is the code I use to generate them:
Public WBToolbar As Office.CommandBar
Public Sub FltgToolbar()
' Close previous Toolbar
On Error Resume Next
Application.Co...
|
3 |
10/23/2008 9:01:08 PM |
|
|
Excel web auto-refresh
Anyone know how I can update data from web once per second instead of once
per minute?
Many thanks
tp
...
|
3 |
10/23/2008 4:55:27 PM |
|
|
Blank book not automatically displaying on Start of Excel
I am using Excel 2007. I created and saved some macros in my personal macro
workbook. Initially I forgot to re-hide the personal workbook. I hid the
workbook today, closed Excel. Now whenever I restart excel it no longer
opens a blank file for me such as Book1. I have to manually choose file new.
Any ideas on how to get the automatic loading of a blank file when the
program starts?...
|
1 |
10/23/2008 4:43:01 PM |
|
|
Chart Dates Difficult to Set
How do you set the parameters of a chart so that the quarters
correspond exactly to the major unit and the months correspond to the
minor unit?
I have an XY (scatter) chart - I need this type of chart, to use the
trendline feature during the year. The X axis data Number type is set
to Oct-08 format. I've set the Scale Minimum to Oct-2007 and the
Maximum to Jan-2009, because I want to see m...
|
2 |
10/23/2008 12:43:53 PM |
|
|
Licence?
Hi,
I have a website, using some db data, I would like to create xls files
on server-side (in c# or vb), then give a possibility to download it
by user (or send it via email)- all I need is an Excel- I could create
a file and send it from my code on server side- which licence is
needed (excel only!) to such a functionality?
Regards
BartlomiejD...
|
1 |
10/23/2008 10:36:03 AM |
|
|
Copy value from cell with custom format
Hi,
I want to copy values from cells with a special custom number format.
i.e.
the cell value is displayed as 1060028 but it's literal value is 28.
When I look at the number format in "format cells" it says the number format
is 10600##. If I copy this cell from one to another even using "paste
special values" it only returns 28.
How can I copy the cell value 1060028 as a complete s...
|
5 |
10/23/2008 9:17:01 AM |
|
|
Pivot table filter row by today or later
I have a pivot table with dates down the left side row and data in the columns.
I want to filter out any dates that do not occur after today. The key being
that today should be dynamic [such as @now() ] and not have to be manually
reset everyday.
The date filters have various options but none allow use a formula or
reference that is true dynamic.
Thanks for the help,
M...
|
3 |
10/22/2008 10:22:01 PM |
|
|
Pivot Table Question
Hello,
I have 2 worksheets with similiar data from 2 different systems. For example
worksheet 1 has:
FileID Expense Type Total
1234 Repairs $100
5678 Rent $300
worksheet 2 has:
File Expires Expense Type Amount
1234 10/22/08 Rent $435
5678 12/31/08 Rent $100
Can I use a Pivot table...
|
2 |
10/22/2008 10:03:17 PM |