Search results for query: *

Hi I need to create a standard column chart with two series of data with vastly different orders of magnitude and therefore need 2 y axes. Eg: apples 3.2 976 bananas 1.5 457 cucumbers 2.3 789 If I use the recommended 'format: selected data series : 2nd axis' to create a 2nd Y...

If you need to just see the "B" but not use it, a quicker way would be to: Highlight the column Format... Cells... Number Tab... 'Custom' Change the custom format to: "B"# Pete

I knew you wouldn't let me down! Thanks a lot. Pete

I don't think there's an answer to this but you guys never cease to amaze...... I have a sheet with lots of big numbers & formulas & want to change the display so all numbers are displayed to the nearest thousand (ie 1,234,567 becomes 1,235,000). But, I don't want to lose underlying data...

Thanks Geoff - that's great, I never knew that function existed! If you hadn't been starred already, I'd star this time!!

Everyone knows that you can refer to the worksheet name in headers & footers by using the &[TAB] function, but.... is it possible to do this in a cell? I can't figure it out - can anyone help? Pete

Simple I think. Select all (CTRL A); Right click any column header and click 'Unhide' Should do the trick

I have a many-worksheet workbook and need to find/replace in the header and footers. Each header and footer is slightly different so usual multiple selection of sheets and editing won't work. Any ideas?