"Hi I have a very large column with scientifc numbers that I would like to
change them to a regular number or text.
I don't want to change them manually one by one. Is there any formula to do
that. See example below

I need the help of an expert here:
I have a table of data that shows the routings of documents assigned to
different departments in a company, as each document proceeds through the
approval process from person to person.  The table displays the information

I'm having massive issues saving Excel worksheets.
When I have Sheet1 open, I can edit and save as much as I like with no
problems.
When I have Sheet1 and Sheet2 open (Sheet 2 has links to Sheet1) and make

Column A     Column B    
A                  -
VOA             C
OA               C

I have increased the prices on my price list by a %, now I need to roundup
the prices to the next dollar.  I have three columns that are linked so that
when I increase the prices in one the prices in the other automatically
increase also.  Can I round up the columns individually?

My relative reference button on the macro recorded disappeared.  Does anyone
know how to get it back?  Thanks.

I have a spreadsheet with a value of 123.889977 in cell A5
I have formatted it to currency and 0 decimal places so it looks like £124.
This figure is derived from a sum.
In cell C3 I have ="Total shortfall is "&A5

Hi. I am new to excel macros/vba/worksheet functions although I have used VBA
in Access. I have  a user who has a worksheet with this formula:

How can I hyperlink from Excel spreadsheet to WORD document and preserve the
link?  When I close out and go back into EXCEL, the hyperlink is lost.  
Please help me!!!  Thanks

I would like to create a link in a excel file. In which I can click into this
link to show another excel file. (The same when you click in a link in
webpage and it open another webpage)
Appreciate your suggestion.

Somehow I turned off my sort button in excel 2007. Actually, all my options
in Data tab are disabled now and I want 'em back on. Any idea of how can I
make it?

What I want to do is have a drop down list of names.  After selected I would
like the macro to sort the various other sheets for the variable selected.  
Is there a way to build a macro like this?  Thank you.

I need to average a list of minutes and seconds in mm:[ss] format (the only
format that would display them properly):
0:35
0:40

I have a workbook that performs financial calculations on information
provided from another department. The calculations work wonderfully and the
formatting is good. However, in order to keep the workbook flexible, it is
preset to calculate up to 50 years worth of information. We ...

I have a spreadsheet with 2 columns. The first column is the start time and
the second is the end time. They are shown in military time. I want to
calculate the difference between the two so I can get hours worked but when
the time overlaps days I get no result. For example if a ...