custom format

  1. K

    Custom number format

    i am importing numbers in a classification hierarchy in the form of 00:00.00. Excel won't accept this format without converting it to some type of time. For instance if my number is 84:24.04, it will convert it to 24:24.04. That is after I change the standard custom of mm:ss.0 to mm:ss.00...
  2. M

    Custom format - show only the 6 first characters

    Hello, Small problem. I have wide table for punching data. For many columns there is the same two word as headers. (the dates might change so can't use formula in the tableheaders). Creating the table will then leave me with: Budget | Actual | Budget1 | Actual1 | Budget2 | and so on. So I...
  3. R

    Adding unknown text to custom number format

    Hopefully this should be an easy question for someone although I've been struggling with it on and off for months! We have various cells in our worksheet that will always have the following format (example) - WC-18-001A, WC-18-001B, etc. I would like for the user to just be able to put in the...
  4. A

    Custom formatting 19-21 character long string with leading 0s

    Hi, Our accounts numbers look like this: 0034-43070-3000-260-561-99 I am creating an excel file where the user, ideally, would want to type in the above account number without hyphens into a cell and then the formatting should automatically insert the hyphens. Problem(s) I ran into are that...
  5. S

    Merge Custom Format $14.9M to Word?

    I have a column of dollar amounts in the millions. Using Custom Format $14,920,569 now appears as $14.9M. However, when I merge to a Word doc the formatting disappears and just the eight numbers appear. How can I make this work? Custom Format [>=1000000] $#,##0.0,,"M";[<1000000]...
  6. J

    How do I multiply two cells with different cell formats?

    I am trying to do this equation in excel but am not getting the right answer 80:00:00 x $13.66 The 80:00:00=hours worked (calculated from a large formula), the format is [h]:mm:ss $13.66 is the pay (entered straight into the cell it resides in), the format is currency The answer is get is...
  7. T

    Custom Formatting for percent

    We always show negative %'s with () instead of the - sign. However, when it's a rounded 0, but still negative, instead of (0%), we want to show 0%. We have various work arounds but none are great. I would like to use a custom number format over conditional formatting. I've gotten this far...
  8. A

    custom number format

    is it possible to use a custom number format in a pie chart to show the number required as a value, and also as a % of the Total. So, say you have 4 distinct elements to the pie chart. Values might be Element 1, 300, element 2, 100, element 3, 200, and element 4, 500. Grand total is 1100...
  9. G

    Formula fails when Excel openned in diff locale settings (decimal point v comma)

    Hi, thanks for reading! Using Excel 2007 and cant share file right now but it's easy to explain: Basically, I have a formula calculating the difference between 2 cells which are custom formatted to display seconds in this way: hh:mm:ss.000 and calculations are done with these numbers which...
  10. K

    Pulling in a custom format using a fixed or text formula?

    I am attempting to automate some reports that I do in excel by creating a format I can simply copy into word. In the word doc since the numbers are high numbers I translate to a more simplistic form, for example ($14,175,380 would translate into $14.2M). I am using a custom format IN EXCEL...
  11. M

    Custom Serial Number Format Based Upon Julian Date.

    Hello: I need to create a serial number that auto increments based upon the following format: Last two digits of the year + Julian day of the year + two digit unique incremented number. 1610604 would be 2016 on the 106th day and the 4th unit and the next number would be 1610605. I do not...
  12. C

    Custom Format With Space

    User enters text into a cell such as: T2K5G1. I want the custom format to convert that to: T2K 5G1. So it's the same thing with just a space in between. I tried 000 000 in the custom format but that didn't work. Suggestions?
  13. S

    Formula in Custom Number Format

    Hi. I know, I am asking too much here. But I have seen much weird (!) things happened with excel so I dared. Ok. My question is, Is it possible to use formula in Custom Number Format? e.g. I have 2 values: Sales of the month, Closing stock of the month on the basis of these 2, I calculate...
  14. S

    Custom Format with leading zeros?

    I have a column of prices which need to be displayed in a four digit format without symbols. It also needs to keep the 4 digit format when used in a concatenate formula. $3.99, $5.00, $.47 should display as 0399, 0500, and 0047 and in the center of the formula as 1501x0399x1523. I either lose...
  15. Prevost

    Custom Date format increments by 1 hour and 59 minutes

    Hi There, I have a custom date format cell in the form of DD/MM/YYYY hh:mm . When I fill the series, it increments the hour value by one each time, which is what I want to happen. However, after a bunch of cells, instead of incrementing by 1 hour, it increments by 59 minutes. So it goes 01:00...
  16. R

    Explain the options for the FormatConditions and StopIfTrue in Custom Formatting for a selected range

    Explain any options for the statement: FormatConditions(1).StopIfTrue = False The code works as intended. I just don't understand the values. Just wish to understand why it is always a (1) and = False in the examples. Also, want to know if there are any additional opportunities to have other...
  17. L

    Custom code to output cell range as string...

    I have come across this wonderful piece of code that kind of accomplishes what I am after, to a point. Though I would like the output string to be displayed with a few extra characters. Function Concat(rng As Range, Optional sep As String = " , ") As String Dim rngCell As Range Dim...
  18. N

    How do I force a comma between two 4 digit numbers?

    I want to put a comma between two numbers in a cell without a space, for example: 3055,2666 I tried using the custom cell format to force the separation but it didn't work. The comma keeps on separating the numbers into 30,255,666 Any ideas?
  19. M

    custom format - extract text value for conditional processing

    Hi - is there anyway to interrogate the value of text in a cell that is custom formatted? I have a spreadsheet where cells in a column are formatted as: #,##0.00" USD";-#,##0.00" USD";#,##0.00;@ #,##0.00" PHP";-#,##0.00" PHP";#,##0.00;@ #,##0.00" MXN";-#,##0.00" MXN";#,##0.00;@ ETC. I would...
  20. V

    How to read value from a cell with custom format mask

    HI, I am facing below issue. Please help me. ( using Excel 2010) I have 2 excel sheets. 1. In first excel sheet user enters any number and it has custom format mask of '000000000000000'. This format mask is not fixed. It varies from cell to cell. Ex : if user enters 1234567890 then it will...

Some videos you may like

This Week's Hot Topics

Top