number format

  1. T

    Formatting Number Resulting from VLOOKUP

    Hey Folks, I couldn't find anything on the forum about this so I'm hoping someone can help. I have a data extra that I take out of a reporting tool and I use a VLOOKUP on another tab to get a value out of that data. The problem is, the data in the extract comes in showing 6 spaces past the...
  2. K

    Conditional formatting in VBA dependent on the text string in adjacent cell.

    Hi. If someone can please give me some advice, that will be grand. D7:D16 say either "POUND", "PERCENTAGE", OR 'NUMBER'. E7:E16 say a number ranging between 0.01 and 10000000 I effectively want to code in VBA so that E7:E16 will be formatted corresponding to the adjacent text string. So, if...
  3. R

    VBA to convert the range B in number format??

    Hi All, I need a help where I have the numbers in column B but they are not in the number format. So I want the moment my macro paste the data in column B, it should convert that column in number format. I have tried multiple time but it only paste the data in as usual format. Kindly advise...
  4. M

    Cannot keep leading zeros in hyperlink address

    This is a code that creates a value in a cell based on the previous line number, it then hyperlinks this cell to the associated file folder for that Inspection number Range "G" is the cell to receive the hyperlink. =SUM(R[-1]C[-6]+1)" Takes the previous line number in from one row above...
  5. E

    Help with number formatting on a cell with a number range (formula)

    Hi all, I have a formula which pulls in a number range (e.g. 1000 - 2000) based a lookup, as below: Salary: £15,000 Rating: 3 Recommended increase %: 1-3 (based on Lookup in table) Recommended amount: 150-450 (calculation as 1% and 3% of the salary field). Formula is...
  6. P

    Extract currency code from another cell to include in a cell's number format ?

    Hi, I searched a lot for this but I couldn't find a solution for this. I wonder if you could help.. To explain my problem, I have created this example. Please see the table below. I am given Travel cost, Logistic cost and Accommodation cost in GBP (£1200, £1000, £1000 respectively) These...
  7. T

    Number Formatting in a cell with a formula

    Hello, I have cells in column A that are directly linked to other cells in a different tab. For example, cell A1 = ='Tab2'A1 However, I am trying to keep the number formatting so that my numbers have a leading 0 (8 digits total). For example, "920" should be reading "09200000". However...
  8. M

    Help with Case Selection changing number formats

    Hi Forum, I created a case selection to change number format by pressing at shortcut so the selection will change from Comma to Percent to Currency and then back to Comma. Code below. The problem is when I select more than one cell and one of the cell in the selection has a different format...
  9. D

    Format number 0.000,000 to 0'000 ?

    For example number 67,194 (194 are decimals). I'd like it to appear as 67. A bigger number e.g. 12345,194 would appear 12'345. I tried NumberFormat = "0'000" and = "#'##0", but they don't work. The first gives 0'067, the second give '67.
  10. klynshoe

    Custom Number Format

    Hello, I am trying to create a custom number format. Basically I want the same format at the "General" setting, but where zeros are "-" like in the accounting format. Examples 20.5 -->20.5 18 -->18 0 --> - I am using EXCEL 2013. Any suggestions would be appreciated. Thanks, Kelly
  11. T

    Calling Application.Run with built in VBA function as Macro Parameter

    Hello, I am hoping that someone will be able to help me with a problem that I am having for my COM addin. My Problem: I would like to be able to call VBA's Format from my C# VSTO application, but this function is part of the VBA language and is not exposed via COM. Note that I am aware that...
  12. C

    Excel Defaults to Currency as Number Format

    Hi, Excel 2013 keeps defaulting my Number Format to Currency (euros). I live in the UK so this isn't correct, plus I would prefer it just defaults to General and then I make the change myself. How do I change the global setting for this? Much appreciated.
  13. A

    Phone number format problem in excel

    Hi Experts, I am facing a problem. Whenever i put a phone number into cells it converts to formulas and i tried finding the solutions on google and found some solution format cells etc but nothing is helped me. I have shared a pic sample below. Please help if someone knows a solution it. Also I...
  14. S

    Format number from named range in text string

    Hello, I'm trying to use a named range in a text string. I've almost got it, but the output is a number with several decimal places. On the originating sheet, I've got the number format set at 0 decimal places. Here's my example: Named Range from the sheet: "KFH-HP Golf Scorecard" =...
  15. C

    Can I create a toolbar or button to apply a number format?

    I want to create a toolbar or a button that I can press to apply a custom number format (it's basically just putting the numbers into millions). Does this require VBA? I have basic VBA skills, so I would be willing to go that route, however I normally try to avoid putting VBA in spreadsheets I...
  16. F

    text bullets and numbering

    Hi, I have added Textbox into PPT and I want to put there a text with few line - each should be marked by bullet (dot or circle) or by number (like 1, 2). Example: 1. Some long text 2. Other text etc.... How can I do it? activeSlide.Shapes.AddTextbox msoTextOrientationHorizontal, Left:=0...
  17. J

    How to remove °C from cell

    so ive tried using the formula To remove °C from 10 °C for example =LEFT(E10,LEN(E10)-SUM(LEN(E10)-LEN(SUBSTITUTE(E10,{"A","B","C","D","E","F","G","H"},"")))) In an attempt to remove it but i get 10.0 ° Theres still a degree remaining, how do i completely remove this?
  18. D

    Number format force 2 digits

    Hello everyone, I hope I have an easy problem. I copy data from Navision our ERP software to Excel. I then remove all duplicate entries. I am having a problem due to number formats. Some of the data is 2 decimals and some is not. So when I copy two lines I get Apples 1622 Apples 1622.00...
  19. L

    Number Format

    How convert/show number format from 8.123,00 to 8,123.00 in Excel 2010.
  20. 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...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top