format cell

  1. H

    How to get excel to ignore "<" when conditionally formatting?

    Hello, I am trying to conditionally format rows C and D so that excel highlights a value when $D94>$C94 (for rows C94:D118). So that when successful, excel would highlight cells D112 and D116. However, it seems that the "<" in front of many of the values in column D is throwing off the...
  2. J

    Format Cell to Divide by 1.1

    Hello, First time posting here, how do I create a formula to divide a number say 60 by 1.1. I'm trying to create a sheet that with a Header Column "Unit $ ex GST" and have the 10% excluded from the price in Excel? Any info would be appreciated? Thanks
  3. tlc53

    Bank Account Format - Data Validation

    Hi there, I'm trying to set the format of the cell to format numbers into the following; 00-0000-0000000-000 So when 16 numbers are entered (no hyphens), it automatically comes out looking like this, for eg. 12-1234-1234567-123 But if only 15 numbers are entered, the third to last number...
  4. P

    Copy formats from an indirect cell

    I managed to copy cell formats <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono"...
  5. K

    Cell Format # filler is displayed

    Whatever cell format I choose, the # filler characters are always displayed. E.g.: For a selected display '$'#,##0.00, we see $#,##1.36 rather than $1.36. What is wrong ?
  6. S

    formula keeps changing

    =INDEX(Enumbers!C2:C60,MATCH('final data'!B2,Enumbers!B2:B60,0)) Question: the above formula is giving me some issues. i have a work around but it is long. the formula is correct BUT i need to move it to several cells and the formatting of the formula must remain the same. Enumbers!C2:C60...
  7. I

    leading zeros with both numbers and letters in string

    I need to add leading zeros before two separate strings for all in column E. For example: <colgroup><col width="111"></colgroup><tbody> 0336565-CM </tbody> <colgroup><col></colgroup><tbody> 336700 </tbody>
  8. A

    Help me separate a number and a formatted text into two columns

    Greetings! I have a column in a spreadsheet with cells each custom formatted to display a number (indicating quantity) and a unit of measure (such as lb., kg, can, pc, etc.). I need to separate this column into two formatted as number and text displaying the numeric value for the quantity and...
  9. D


    Does anyone know if it is possible to adjust a paragraph to 1.5 line spacing in excel? specifically I have a concatenation formula mixing word and text in a merged cell box and now would like to format it appropriately. Many thanks in advance!
  10. P

    Cells Time formatting

    Hi, I have a pb with the cells formatting for a time: In a cell let's say A1, i would put a time, for ex: 08:00 and I would like to retrieve this value for the use of an Application.OnTime function However excel considers my 08:00 as 0.3333. I tried to format my cell A1 in time category but it...
  11. V

    IF cell Contains "text" then lookup "Colour"

    Hi all, I need to format a column/set of cells where each cell has some text in it, and depending on a defined list elsewhere that text does a contains lookup to see whether to colour that cell in Green/Amber or Red. I was going to use the conditional formatting traffic lights but I dont know...
  12. G

    Excel Macro - How to make whole column always Today's date

    Hi All, Background - I have 2 Excel Files A and B I manually copy all data from File A to B exact copy. I am Reading from File B only ( dont ask why not read from A as its a process) B After I copy the data to File I Read Line by line to a Sessions Screen to do that I need to make all...
  13. B

    Custom Format Cells Formulas

    Hi, I need the following to happen column A contains numbers.... in column B, I am trying to input a formula for custom format: so that the numbers will appear as such column A: 32,458,000 ; column B will show +32MM column A: -100,000 ; column B will show -100K im currently using the...
  14. V

    Conditional Formatting

    Hello, I want to conditionally format columns based on quartiles. I am able to conditionally format single column at a time but I have more than 100 columns to format. It's time consuming to edit cell values for each column. So how I can put condition in conditional formatting which is...
  15. V

    store formatted cell into variable..

    I want to store the formatted cell into a variable and then send that value into mail as body text.. eg:- i have a sheet in which i have a row give below, i just want to save the data as per it is formatted into a variable and then want to send as body text in mail.. <tbody> Hello Sir, this...
  16. E

    Format Data Labels all at once

    Hi, wondering if anyone can help me, I have a chart which has a LOT of series...and I want to show the data labels of only the series, which aren't equal to zero. So, basically, the way around this I have is to format the data labels to "#" (which sets zero to blank). However, I can only...
  17. A

    Decimals auto added to formatted cells..??

    I am having a problem where Excel 2013 is automatically adding 2 decimal places to cells that I have formatted to NOT show decimals. The decimals show up whenever I type a formula using a percentage into either that cell or into a cell near it. It appears to be random when this actually...
  18. O

    Force cell entry strictly to mm/dd/yyyy

    Using Excel 2007, and I want to force entry to calls in a date column to the format mm/dd/yyyy. Currently I have the cells formatted for mm/dd/yyyy and entered data validation date range between 12/31/1999 and 12/31/2060. However some users are too lazy to look up the day case start and just...
  19. S

    Combine date and time to create a perfect dataset with 24H per day for a periode of two year

    I have a model that works nicely with a time reference every day. The problems starts when I want to take advantage of the fact that I have new data points from measurements every 15 minutes. I would very much like be able to aggregate my data at least on hour basis and not just days in order to...
  20. T

    How to format two numbers into two currency units, with a "to" between them?

    Hello. I am creating a simple inventory, and for one of the columns I would like to have a range of sorts. In theory it would look like "$30 to $50". I was wondering if there were a way I could just enter "30 50" and it would format it to two separate currency units with a "to" between them...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back