format cell

I have a lookup formula that is returning values to include in a part number. The value that comes up might be "2103" or "5242698" but I need them all to be formatted with 8 digits so I want the appropriate amnt. of 0s to be added. i.e. Formula Value / Required Format 2103 =...

I have a table that looks like this: A $125,000 B $350,000 C $109,000 D $122,000 The values come from formulas on another sheet and change frequently. The table gets attached to a publisher document that goes out to clients and row D has an important disclosure. Because of...

Hello, How can I custom format a cell to display the currency three-letter formatting based on an input in another cell. For example in Cell A1 I would enter ZAR and the format would be applied to a certain range. I am thinking it would be some sort of code applied to a button to press after...

I am pulling a cell value in VBA formatted as percentage (0.00%). The value I have in the cell, for example is, 5.13%. I'm taking this value and displaying it in a label on my form. For example, txtTax.Caption = Format(TaxRate, "0.000"). The variable TaxRate is a string. But the value...

Good day all! Question!> How can I convert / insert text into a cell to have it changed into a date? I downloaded a calender from a website in excel format. bu the dates are all "YYYYMMDD" eg. 20100114 How can I either insert an dash " - " inbetween them all or convert them into a date...

Hi, I have a column called "duration", which shows the length of a phone call made. It has been given to me in the format of hh:mm:ss, so that 00:00:35 means a 35 second call, 00:15:42 is a 15 minutes and 42 second call etc. In essence, though, because of the format being a time format...

I have a text column of 7 to 9 digits in length. Some items have 2 leading zeros and some do not. My formula in other areas will not work on the items without the 2 leading zeros. I know how to Custom Format to get them BUT some of the 5 digit items look like this (2BE21, 25E51, etc.). If I...

Hopefully there is an easy solution that is alluding me. What I have is a sheet that has different questions represented by each column, students and their answers in each row. I need to compare the answer for each student with the correct answer at the top of the column. If the answer is...

Hi All I am making my own budget and have trouble doing the following: From my online bank I export all my account activities one month at a time to their own sheet: January, Febuary, March etc. I have one sheet i call "calculation" which have the months as columns and expenses posts as...

I am using Mac Excel 2004. I was given a pre-formatted spread sheet to work on that has columns with dates stored in it. Some of the date columns are formatted as general and others are formatted as date. The ones that are formatted as date display the excel 1900 date storage number in the cell...

Hello! Using Excel 2007. I am able to format specific text within a cell, but the formatting only appears when editing the cell. For example, if I have a cell that contains and has been formatted as follows: The federal deficit projection is redfor the foreseeable future. It will appear...

Hi I am using =mid to pull data into a table from a worksheet, the data that is pulled across should fall between certain ranges and i was wondering if there was a way to either make the test bold or add a * if it fell out of range. I tried conditional formating but it wouldnt work as the cell...

Hi I have a cell which I wish to conditionally format so it takes the same format as the one to the right of it, is there a way of doing this?:biggrin:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

:confused:.... So I am trying to apply conditional formatting to a document of mine and I cant seem to figure out how to make this conditional formatting work. I have in column A numbers formatted this way, here is an example: 00087965. When the numbers are not formatted this way I need it to be...

Is there a way to hide formulas other than format cell/hide then protecting sheet? I see several threads on the subject but it seems that is the only solution people recommend. That solution does not fit my needs. Can anyone help with an alternative? Thanks in advance.

Is there a way to hide formulas other than format cell/hide then protecting sheet? I see several threads on the subject but it seems that is the only solution people recommend. That solution does not fit my needs. Can anyone help with an alternative? Thanks in advance.

I am trying to add a zero to the end of a series of numbers. I have a list of 20,000 customer numbers, some with 5 digits and some with 6 digits. Example some are 123456 and some are 12345. I need to make them all 6 digits long, so I decided to add a leading zero to them. I made a custom format...

Good evening, I have basic skills in VBA and I have made a VBA-based user form in my workbook. It is a simple member list for our small organization. It has name, mail-adress and phone number fields. With my form the user can add or remove members easily. (or thats my purpose anyway) By...

When you right click on a cell and select format cells, you can easily rotate 90 or -90 degrees, but I need to be able to rotate a cell 180 so that it is completely upside-down. Does anyone know if that is possible? Thanks in advance for any help.<?xml:namespace prefix = o ns =...

Very simple issue here. I come update my excel everyday after the stock market closes, but I have to many entries to manually update. I need a one or two click solution. In A1 I have a ticker symbol, and in B1,C1,D1,E1,F1 I want to show the percent change 1,2,3,4, and 5 days after I post the...