|
|
Changing mulitple tab names by
RD[_3_]
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...
|
|
4 |
41 |
|
|
|
|
5 |
169 |
|
|
Changing Multiple Formulas by
stevieboy1313
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...
|
|
1 |
104 |
|
|
Changing Multiple Formulas by
John Pivot Table
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...
|
|
6 |
84 |
|
|
Changing multiple formulas at one time by
poorsister
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...
|
January 6th, 2006 04:41 PM
by Pete
|
2 |
78 |
|
|
|
March 18th, 2004 02:55 PM
by Andy B
|
1 |
600 |
|
|
Changing my functions to use subtotals? by
cherman
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...
|
December 22nd, 2009 02:32 AM
by T. Valko
|
6 |
160 |
|
|
|
|
2 |
75 |
|
|
Changing negative numbers to positives.. by
Ela
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...
|
|
3 |
325 |
|
|
Changing number format by
gcotterl
How do keep a cell, formatted as Category = 'Custom' and 'Type' =
00000000000 from getting changed to Category = 'Special' and Type
'Numer PESEL' and...
|
|
0 |
139 |
|
|
Changing number in cell when printing by
JLee
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...
|
|
2 |
56 |
|
|
Changing number to mins/seconds by
Katie
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...
|
December 9th, 2009 11:02 PM
by Katie
|
2 |
124 |
|
|
Changing Numbers by
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...
|
|
4 |
115 |
|
|
|
|
3 |
77 |
|
|
|
|
7 |
277 |
|
|
Changing numbers to text by
Des
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...
|
April 9th, 2007 08:58 AM
by Toppers
|
1 |
57 |
|
|
|
January 19th, 2007 02:09 AM
by Alan
|
7 |
75 |
|
|
|
March 20th, 2009 02:20 PM
by BTM
|
2 |
73 |
|
|
CHANGING NUMERIC FIGURES TO WORDS by
RAJEEV CHADHA
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...
|
|
3 |
190 |
|
|
changing numeric value to text (in words) by
gaurang
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...
|
|
2 |
257 |