number format in text

  1. K

    Numbers as 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...
  2. 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...
  3. L

    Formatting numbers in TEXT

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

    VBA Excel - Does cell have number formatted as text?

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

    Number stored as text

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

    Seperating Numbers

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

    Using Forms and Numbers

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

    Vlookup, Match functions do not work

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

    Losing formatting when inserting into text

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

Watch MrExcel Video

This Week's Hot Topics

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
Top