| Thread | Last Post | Replies |
|
| How I can transfer numbers in to text | 10 Feb 2006 09:11 GMT | 3 |
I had made account in excel and I entered the amount in number format. Now I want to transfer that amount in to words in other cell. Is there any formula excel have that transfer the amount which is in number format to words format?
|
| adding hexadecimal numbers | 10 Feb 2006 08:46 GMT | 3 |
As the subject states, how do I add together cells containing hex numbers. I tried the following... A1 contains 0f
|
| How to Sort Invalid Email Addresses? | 10 Feb 2006 05:36 GMT | 10 |
My customer base of 5,000+ records (columns a-l) has some invalid email addresses in column g. The "@" is missing. I would like to have those particular email addresses sorted at the beginning of the list so that I can go through them and see if they can be corrected or deleted.
|
| Excel 2003 convert hours from GMT to PST?? | 10 Feb 2006 04:51 GMT | 6 |
I have a huge log file that has time in hh:mm:ss GMT and I want to convert those time to PST. I need to subtract 8 hours from the GMT time, but I cannot figure out how to do it. Any ideas?
|
| count rows of a filtered list | 10 Feb 2006 04:30 GMT | 1 |
Hi I am often counting rows in a list that has been filtered. is there an easy way of finding out how many are in the filtered row, thanks tim
|
| Having columns match numbers in one column | 10 Feb 2006 03:48 GMT | 2 |
Good Morning All, Excel XP Example: A B C D E F
|
| can a column have diffent width? | 10 Feb 2006 03:25 GMT | 2 |
I have dates in column A and 20 rows down or so, I want to have names in column A and numbers in column B but column A must be wider to accept the names. I want the dates to be a certain width say 64 pixels and the names to be 336
|
| LIMITING CELLS TO 2 DECIMAL PLACES IN EXCEL | 10 Feb 2006 03:11 GMT | 4 |
I have a small issue with an excel list that I am pulling information from. Its a basic price list pulled from another companys list. The problem is the company that the price originate from use an equasion from another list to derive the actual totals. this means that numbers
|
| How to hyperlink to an image on a different sheet and display it f | 10 Feb 2006 03:11 GMT | 1 |
I have 2 tabs, called "Sheet1" and "Sheet2". On "Sheet1", I have hundreds of one line feature descriptions for my product. These descriptions are of course text. On "Sheet2", I have inserted hundreds of screenshots of my product. Now comes the fun part...
|
| Scrolling down on a cell | 10 Feb 2006 02:58 GMT | 1 |
I have more than a 1,000 lines of text per cell and several cell in a worksheet. I cannot see all content in a cell and wonder if there is a way to insert a scroll down on the right side. Thanks White
|
| Creating a new formula | 10 Feb 2006 02:04 GMT | 3 |
I have a worksheet for active employees in one department and another sheet for active employees in another department. Now these will remain in their distinctive active sheet until their active status is change from Y to N. I have created a third sheet where I would like excel ...
|
| Is it possible to highlight text? | 10 Feb 2006 01:56 GMT | 11 |
I'd like to highlight just some of the text in a cell - not the entire thing. Thanks
|
| Comparing multiple numbers - I am in agony | 09 Feb 2006 23:53 GMT | 7 |
I have to compare 6 columns of numbers that have various integers including 0s and sometimes null data. I need to know if all the data is the same in the even there is data Column A B C D E F G
|
| How do I hide zero values but keep currency format in P.O. form? | 09 Feb 2006 23:53 GMT | 4 |
I'm creating a purchase order for our company and am having trouble formatting some cells. I need a currency value in the Total section only if there is a value in the Quantity and Unit Price section. I formatted the Total cells to Currency. But if there are no values in Quantity ...
|
| Double Clicking On Cell To Edit Data | 09 Feb 2006 23:40 GMT | 2 |
I modify existing cells contents quite frequently. Using the mouse and double clicking seems to me to be extra work. Is there any way via the keyboard to get into a cell to edit its contents?
|