Worksheet Functions - Page 508

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
changing text to numerals by JRD Is there a quick and easy way of changing numbers enter as text (i.e. one, two, three) to numerals. I have a whole column of numbers entered in text form...	August 24th, 2006 04:54 PM by JRD	3	51
changing text values to a different string by sparks We have cells that are text and 1 2 3 .....110 the problem is now they want them as 001 002 099 100 can can the 1 2 3 98 99 be converted to leading 0's...	July 16th, 2007 07:01 PM by Pete_UK	4	71
Changing the apperance of values by Rhatch I have a work book showing a quantity on hand, quantity in stock and the variance between them. I am wanting to formate my variance column to change eveny...	June 2nd, 2008 08:29 PM by Rhatch	2	69
changing the background color on a single column by I am trying to change the background color on one column. The only thing it will let me do is change the background on the whole table. Can someone please...	January 30th, 2004 10:32 PM by Lady Layla	2	157
Changing the case of text data by fuzzyjon Hi everyone I currently have a set of data which is all in upper-case text characters. Before I can merge the data with another column I need it so that...	May 15th, 2006 04:50 PM by	4	80
changing the case of typed information by Malley If I typed a sentence as lower case, is there a way to change the sentence to upper case without having to retype it? I've tried the UPPER function but I'm...	February 21st, 2008 01:14 AM by Gord Dibben	3	61
Changing the cell contents from decimal to fractional by Brian Denny I was sent a spreadsheet with descriptions of product we sell. In each cell, displayed is a fraction, however if you click on the cell you see the decimal...	November 20th, 2006 12:15 AM by macropod	1	73
Changing the Color of a Word in Formula by Rebecca Cribb via OfficeKB.com I have entered this formula: =IF(B52000,"WARNING",IF(B52000,"OK")) I want the word "WARNING" to show up RED and BOLD-TYPED. Is there a way to do...	January 27th, 2005 05:03 PM by JulieD	4	174
Changing the color of cells by formula by Emerogork I wish to change the colors of cells relative to values in other cells in the same row. This is to be done automatically by formula. Can this be done?	August 24th, 2007 12:32 AM by Pete_UK	1	53
Changing the Color of Specific Characters using a Macro by Frustrated IT Tech Could someone please help me with this problem. I am using excel to sift through thousands of protein and amino acid codes abbreviated by letters. These...	April 26th, 2008 05:19 PM by Gord Dibben	6	101
Changing the color of the data auto filter buttons by Jane P Presently the active buttons are blue against a grey background and not very visible. How can I change the active blue to a brighter color?	September 11th, 2008 04:43 AM by Héctor Miguel	1	73
Changing the colour of a logic expression by cjrrussell Hey guys I have this logic expression in a spreadsheet =IF(C19C18,"YES","NO") What i want to do is if it returns a value of NO make the text red. Is this...	December 8th, 2005 04:36 PM by Bob Phillips	4	166
Changing the colour of a range of cells, some with formulas. by Champ Hi there I'm hoping someone can assist me. I am wanting a range of cells shaded grey, one of which includes a formula that specifies its date, and if the...	February 3rd, 2009 09:21 AM by Pete_UK	8	78
Changing the columns to copy by fullers I am trying to write a macro that will copy 3 columns into a new sheet. Once this is done and I have run the other part of my macro I want it to go back and...	July 2nd, 2005 02:14 PM by Debra Dalgleish	1	102
Changing the Date Format by xtian_princess I have a spreadsheet that has a column of dates in the format yyyymmdd, and i need to change them to mmddyy format, but when i use the usual right...	September 8th, 2004 02:54 PM by Arvi Laanemets	1	623
Changing the date format in a cell by scottdog129 I have generated an Excel file from one of our applications, and it has a field for a date with a format of 9-2006. I need to put a leading zero in front of...	August 10th, 2006 04:00 PM by scottdog129	2	56
CHANGING THE DISTRIBUTIONS OF THE INFORMATION by edwinxav Hi the I received a worksheet with data from a survey in this format: SURVEY 1 2 3 ...	May 6th, 2007 06:36 AM by edwinxav	0	60
changing the Duplicate entries by Nitin Kapoor Hello Friends, I want to change the duplicate as well as triplicate entries in a table having some codes with the help of some excel formula....i want to...	October 13th, 2008 09:08 AM by Stefi	1	84
Changing the font of a cell dependant on the outcome by Bemused Scot Hi, Im pretty lost. I am trying to change the font colour of a Cell dependant on the answer in another cell. Also, the cells which I want to change the...	September 25th, 2007 12:01 PM by Bob Phillips	1	66
Changing the font of text in a check box by Iriemon How do I change the font properties in a check box? I would like to have the font bold and a different color. Thanks Irie!	December 2nd, 2009 09:16 PM by Gord Dibben	3	108

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed