Is there a way of changing tab names in one or two steps? I have 52 sheets each one carrying last years names for each week: May 1-7; May 8-15 etc. Can they...

A sheet contains a list of prices that change weekly - 30 products vertically each with a column for each weeks price. Each week a new column is added to...

We are working with some pretty good size worksheets that have multiple formulas. How can I change a reference in several formulas all at once, without...

Hi, I have a file with literally hundredths of formulas and I need to do the same change in all of them; if a certain cell is empty the formulas shouldn´t...

I have a workbook with 30 worksheets that all have approximately 100 formulas that read =(Cell)*.0342. I want to change the formula to read =(Cell)*($AA$1) so...

Hi all, I'm hoping someone here can assist me. I'm working with a series of linked workbooks that are undergoing structural changes. These workbooks have...

I have 2 functions that are calculating my data correctly, except now I need to consider the autofilter. I figure using subtotal is the way to go if I want...

how do you change the names in the cells in the sales phase categories, because everytime i try doing it by inserting a new name by using the define option,...

Hi, I imported a column of numbers and most of them are negative (XXXXX). How can I change them all to positives????? I know that formatting does not help...

How do keep a cell, formatted as Category = 'Custom' and 'Type' = 00000000000 from getting changed to Category = 'Special' and Type 'Numer PESEL' and...

Does anyone know if there is a way to print subsequent numbers in a cell when printing such as: If I was to put number 340 in cell A2 than next page it will...

I want to change data that is just a normal number into mins and seconds. e.g. 80 --- 1:20 or 1.20 or something, so it is recognisable as 1 minute 20...

Hi In a blank cell type 1.15. Copy it (Ctrl+C). Select the range you wish to change and go to Edit|Paste|Paste Special|Multiply. Make sure you take a copy...

I downloaded an expense spreadsheet and it shows the charges as positive and I need to change these numbers to negative. There are up to 150 numbers in a...

can anyone help me. I have heard you can change numbers into a barcode formatt which can then be scanned with barcode scanner.

How do i change the string of number into text. (Not just the format) When i key in "US$1,234.00", another cell will appear "United States Dollars One...

I am trying to create several linked spreadsheets to form a grading system for class. I have most of the formulas down; however, I am trying to get a cell...

I have a worksheet in which cell C2 has number e.g. 253,754. In other rows I'm placing different values in the C column e.g. C10=8,000; C13=5,000;...

Hi, I have a question.In spreadsheet how a numeric value in one cell get converted into words in another cell.e.g., 41 to be written as forty one...

I have one cell having value $112.50 and I want to put the same in words like One hundred twelve dollar and fifty cents in other cell. Which formula shall I...