I have a basic stock order form with several items on it.  How do I link it
to master inventory  on another sheet so that every time stock is taken it
will automatically reduce.  Appreciate as a novice I need to learn certain
fuctions.  Can anyone just get me started with where ...

I have cell in CSV file that has string 03073E105 in it (this is CUSIP).
When I open it in Excel it looks like 3.073E+108
I understand what happens and why but this is not what I want.
Is there a way to achieve every cell to be treated as text?

Up until a day or two ago, I could select a cell to copy, paste it into
another cell and the original copied cell would remain available to be copied
again (it would be highlighted with the dotted border).
Now, after one paste the copy cell reverts to normal, and I have to

I have a code working very well when I fill cells manually, but when I use
auto fill the code stops working as if it does not exist . how  can I  make
the code work with the auto fill.  
Thank you.

Windows XP Professional
Office 2007 Enterprise
Roaming Profiles with QAT not able to be customized
I first have a new Book1.xlsx open.

Hello, I have Excel 2007
I have a column of logical expressions showing as TRUE or FALSE. No problem
,but can I format them to show 1 or 0  ?
Thanks

Typically, when I press Cntrl + Any Arrow, (and when I am in an empty
cell),  I jump to the first cell with a value in it.
In several documents I am working in, the down arrow simply jumps to
the top of the entire range, dissallowing me from finding the first

I currently have several years worth of stock data all in 1 minute
time frame. I want to convert this into my own desired time frame, for
e.g. 10 minutes, for candle analysis. Note that there is Date, Time,
Open, High, Low and Close as the variables. Market time per trading

I created a column with text data. I explicitly set the cell format to
Text. The values in these cells are "Month", "90 Days", and "Year".
I entered "Month" in the first cell and copied it down 7-8 cells by
dragging the corner. Great. All cells show "Month".

Hi I have made a spreadsheet to calculate golf scores and do
countbacks, not knowing much about vba programming I am wondering if a
user form can be used to enter imformation on to the spreadsheet but
also show on the user form the results of what would be entered ie:

I am in the process of transferring my data from one PC to another. Having
transferred my spreadsheets I have found they do not open properly.
The new PC has Microsoft works and the old has office 2000.  As I am used to
using office 2000 I was thinking of deleting `works` and ...

What do I have to do to remove **ALL** personal information from an
Excel 2007 worksheet that I want to post to a public newsgroup where
anyone can download it? I want to make sure that there is nothing in
the worksheet (aside from the data) that can be used to identify any

Dear Sir/Madam,
I have a worksheet as below:
           Column A        Column B           Column C
Row1    David              Boy                    Form1

I am having trouble with pivot tables.  Need to create a pivottable that
summarizes Total amount of orders by quarter.  I have these columns company
name,country,orderdate, sales rep,shipper, category, product name, unitprice,
quantity,discount%,freight, totalamount.  I was sure ...

if a have a column of cells, say from A1 to A150, and each cell contains a
10 digit number, for example xxx1236xxx, how can I parse, or remove the
first 3 digits and the last 3 digits in all the cells?