number as text

Hi there I would love some help in figuring out how to report subtotals from an existing dataset that has been created by combining values from two separate lists. List 1 - Category: Adoption, Process, People, Technology, Tools, and Location List 2 - Impact: 0 - No impact, 1 - Extremely Low...

Hello everyone, Big fan of the Mr. Excel forum, and first time posting. Thanks in advance for any advice! A small nonprofit that I am helping gave me a dataset that tracks their donations and I am trying to clean it up for them so we can run analytics. However, the dates for each row (1 row...

Hello all! I received advice from one of the pros on here, can't remember whether it was Aladdin or Rick, but it was regarding looping through an array stored in VBA rather than writing to a sheet during a loop. This has made things much faster. However I can't seem to store a text variable in...

Hi everyone, I was wondering if it is possible for excel to pull out the highest number when the digits are divided by dots. Please note the amount of numbers in between the dots are not constant (although they are always between 1-4 numbers). For example I have a table that looks like...

I have an ActiveX combo box with drop-down number options 1 through 4. Whichever option is chosen needs to appear in cell T21. To do this, I went to properties, LinkedCell, and typed in T21. Unfortunately, whenever the list options appear in cell T21, they appear as text. I need it to appear as...

Column A1:A999 contains dates. Output required in B1:B999 in 2 digits or decimal as: For 1 01 12 12 9 09 1.5 1.5 10.5 10.5 22.5 22.5 22 22 A1:A999: Will contain only +ve integers or decimal upto 1 place B1:B999: SHOULD contain 2 digits or decimal upto 1 place

I need to go through all the cells in a sheet and check to see if they are numbers formatted as text and then reformat them as numbers if they are. Someone suggested this: Sub Macro1() For Each C In UsedRange.Cells If IsNumeric(C) Then C.Value = Val(C) End If...

How can I easily convert an array of numbers (>0) to text using VBA? Thanks in advance. hans

Hello, I have a numeric text field that allows 000 to 999. I would like to use a SpinButton control to allow users to enter the number. However, if the number is less than 100 it needs to be padded on the left with the zero character. i.e. 5 needs to be 005, 51 needs to be 051. The...

With my job I need to type what seems like random numbers such as "3H23563" and I want to be able to write all my random numbers and have them automatically convert to a dollar figure. For example: 3H23563 would equal $15.25 in a different column when I type that random number into excel...

I have a userform with a lot of designed and weird code behind it so it can 'look' correctly. Therefore I can't really mess up with that code. However, when I finish the user-form and the data exports to a table I have some problems. The error "number in the cell is formatted as text" came up...