number format in text

Hello I have been using =IF(ISNUMBER('[11.30.2015 Invoice.xlsx]Table 1'!$A23),'[11.30.2015 Invoice.xlsx]Table 1'!$A23,"") to pull a list of numbers off of a column that contained numbers and text. Now the file is being sent to me with the numbers formatted as text, which threw off the whole...

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

I use this formula: =" "&TEXT(COUNTIF(G5:G22,"appr"),"000")&" "&TEXT(COUNTIF(I5:I22,"appr"),"000")&" "&TEXT(COUNTIF(G5:G22,"appr")+COUNTIF(I5:I22,"appr"),"000") to display numbers in a merged cell. The "000" formatting seems to be the only one...

I am working on a macro that loops through a bunch of cells in an Excel 2007 worksheet. It would be most convenient if I could determine for each cell what is in the cell, where the choices are 1) a number formatted as text, 2) a number, 3) a blank, 4) text. The flow in the loop goes...

I have a column that has both numbers stored as text and text. I need the numbers to be stored as number. I have tried to (a1*1) but then on the text I get #value. Trim didn't help either. This is really frustrating because my vlookup won't accept number stored as text. Any help you can...

I'm new to excel and finding it hard to do the following, I wish to seperate a series of numbers into their own coloumns. The numbers are in the format 01:02:03.04 , Note numbers are seperated by colons and full stops. I gather I may need to convert them to text first but all my attempts convert...

please help I have created using VB a simple form, that should put data from the form into the worksheet as a qty. The data is copying across to the worksheet correctly, but is storing the data as text, then i cant find a way of converting this to a number, is there something im missing...

I have a sheet which takes data from two different sheets to compare to each other. I use the trim function on one to get the data to match the other. I am left with a 6 digit number that should be the same for both sets of data. Match, Vlookup, and =A3=B3 comes back FALSE. When I evaluate...

Excel 2003 I want to create some text that includes the contents of a cell, whose contents are formatted as $. When I do so the numeric value is inserted but without the $ or the commas. For example, in cell A1 is a calculated value of $100,000. In cell A2 I want, say, So the amount of...