How to add PivotTable drop down selector to another tab?

[BurgoEng]

In the PivotChart, right click and select Location and select Object in and select the SHEET you want the chart embedded in.

[AlpineMan]

Thanks a lot for replying, I will look into it.

[AdamU]

Cheers and thanks a lot.

[markbenedict]

Thanks that solved the problem.

[lisamapiatan]

Thanks for the reply.

[postonbenito]

I have a spreadsheet with one column that has over 1500 rows. It was actually exported from another application and all of them have a $ at the end of the number.....is there a way to delete the last character for all of them at once? Any help would be greatly appreciated!

[RareBug]

I have a column for which I would like the formatting conditional. The column contains the values Actual , Estimate - switch or Estimate - CALC (I have several more of the Estimate -... values makes some). I would like the formatting of the Estimate -... evaluates all to be yellow thus I would like a manner of writing a function for the conditional box of formatting. I thought that it should seem something like follwing:

= Estimate and *

but it is clearly not completely exact. Any help would be appreciated. I would be satified with a LUCKY FIND or IF solution - something which obtains to me with the

[AlpineMan]

I show a table below. I must count how much time 4 Jane occurs in jan..
If column A were simply Jan I include/understand how with do it but how I make-the with the dates in this help of the format... please...

A B
1/16/08 2 Jam
1/12/08 4 Jane
1/6/08 4 Jane
5/12/07 CCU
5/5/07 2 cohen
4/5/07 4 Jane

[extraction]

Hello-

That should say "numbers' in the thread title

Using Excel 2007 last night at home doing a simple schedule template for about 10 employees.

The problem I'm having is that whenver I enter a time range into a cell it is being changed to a date when I leave the cell. For ex. if someone is working 8-5 it changes this to 5-Aug, a 10-7 shift becomes 7-Oct, etc. I turned off autocomplete for cells to no avail.

I saved the file in the older format but editing here at work I have the same issue on Excel 2003.

Some setting must have changed b/c when I first started working on the worksheet it was leaving my entries alone.

Any help appreciated

Thanks

[Troy2287]

Ok simple to fix.
1.Right-click the desired cell.
2.Select "Format Cells...".
3.On the "Number" tab set the category as "Text".