number format

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...

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...

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...

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...

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...

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...

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...

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...

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.

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

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...

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.

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...

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" =...

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...

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...

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?

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...

How convert/show number format from 8.123,00 to 8,123.00 in Excel 2010.

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...