Search:

I believe that Excel have converted text to number automatically.
Why don't you try custom formatting your cell, it is much more robust

I am assuming that you do not want the subtotal rows
simply click on Data on the menu bar
select Subtotals
click on Remove All

This will remove all subtotals and grand total.

Hi

Does the attached do what you want?

Format the cell M14 by right click
choose Format Cells >>select Custom and choose [h]:mm:ss

HTH

Thanks Prasad and Hans

However it still does the same as you can see from the screenshot below with dummy data, this is with both the & and the Concatenate formula?

Editted: helps if I attach...

Thanks.


Is there a different between running the macro from a commandbutton
and from the workbook's macro

The error happen at Cells.Select when I run it from a commandbutton
but its work...

I'm sorry I can't seem to get your spreed sheet to work, but thanks for your help anyway.


I tried it and its works.

Did you enable the macro when you first open the file and double click on...

You could use code like:

Application.CutCopyMode = False
Range("A1").SelectTo exit CutCopyMode, and re-select the first cell in the worksheet.

You could use code like this to save the new...

The variables would be those assigned by you earlier in the project.

If you need to open an existing workbook the code would change to:
Sub PasteOnlyValuesAndFormat()
'
Cells.Select
...

Assuming that you wish to paste the data into a file whose name is stored in the variable "FN" (without the quotes), the line will change to:

Windows(FN).Activate

The line of code activates the...

Does the following help?

Sub PasteOnlyValuesAndFormat()
'
Cells.Select
Selection.Copy
Windows("Target").Activate
Cells.Select
Selection.PasteSpecial...

Pl have a look on attachment. I am struggling with formating cell to % in 2 decimal places along with up/down arrow. Any suggestion.


Seem like it can't be formatted as percentage due to adding...

Hi

I have a workbook contains formulas and links with 2 Sheets named "Template" and "Data"
The following macro copy everything on Sheet "Template" to a new workbook

The worksheet being copied...

I did it by going to Insert | Symbol, and selecting my required symbols out onto the worksheet. Once I had the symbols in the ws, I copied them into my formula's.

I'm starting to wish that I had...

FWIW, you can simplify a lot and use a custom number format rather than conditional formatting and IF formulas. See attached (cell C1 has the custom format depending on whether it's positive,...

Thanks Mike!

would you mind posting your file to share this
I am still lost as to how to have the symbol in the formula

thanks

It does - just add more sheet names to the list. If you have many sheets, it is easier to enter the sheet names in a range of cells, say H1:H10 if you have 10 sheets. You can then use H1:H10 instead...

Sheet1
__|____A____]____B____|____C____|____D____|
1__|__Pizza___]____ ____|_____ _____|____ ____|
2__|__Bread___]____ ____|_____ _____|____ ____|
3__|_HotDog__]____ ____|_____ _____|____ ...

This means that 7/7, and any date that falls on work days can be excluded, isn't it?

yes

Excel Help is so confused(for me). I found a topic about this function, but didn't understand anything.

I don't know how Excel calculates holidays. Fo example, I added 3 dates: 6/6/2009, 7/7 2009,...

May you modify table with several holidays, and post it again(and, of course, change formula)? I will then change holidays with my data.

Thank you anyway.



Have you carefully read what...

I have some cells (see below) containing * characters:

**Tony
Tony**
To*ny
*Tony

I want to delete the * characters.

When I try to do this with Find and Replace, it removes everything. ...

Hello All,
Is there an easy way I can insert blank rows between rows of text in Excel 2003. For example if my worksheet looks like this

Text
Text
Text
Text

I want a blank row after each...

Hi,

I have a workbook with 11 sheets. For this purpose, I'll call them sheetX (destination) and sheets 1-10 (source).

I want to create an array of sheets 1-10 and for each sheet in the array,...

This may have been asked and I am just not looking for the right stuff.

I have a spreadsheet where the user enters a measurement in inches, and it converts the measurement to Feet, Inches and...

Unfortunately, the attachment was lost (with a lot of others) in the server crash of August 2007.

Perhaps you can use the Timecard template - see Use the Excel Timecard template for quick and easy...