number format

I hope that one of your Excel Geniuses can help me out with this. I have a master product file spreadsheet. When I exported from my Content Management System into a CSV file it created one column to designate the categories each product has assigned to it. For example, "Product A" falls...

Are there any built-in functions which allow me to define a custom number format as a parameter? Failing that, is there any way of creating a user defined function that contains a "format_number" parameter in the same way that the TEXT function has a "format_text" parameter? I have a large...

Can I conditionally format a number format? For example, I have a worksheet that has several numbers that update, and one of the fields is a format field, i.e. $, %. If the format field is $ then I want to format the cell as a number, if the format field is a percentage, then format as a...

I'm trying to set a cell to accept a 4-digit number that may have leading zeros. I've set Numbers - Special Formatting to "0000" but Excel changes it to be a postal zip code from Portugal. Any idea how to keep it from using an existing formatting when I want to use a custom special formatting?

Hi everyone, I am extracting data from an external program which is extracted as the string below...

hi, I'm trying to create a csv file. Is there any way to keep the same figures format as in the initial excel file when printing the csv or shall we define the format of every column in the loop(and how)? Actually in the excel file, some columns contain figures that must be formatted as...

Nevermind

Hello! I'm beginning to lose my mind on this problem. :mad: I made a reasonably complex form, where user (me) must insert a lot of data in (mainly) TextBoxes and ComboBoxes: I wont' bother with translation, but some of you will maybe recognize that I'm trying to calculate heat loses of a...

This is going to be a n00b question but it's bothering me and I can't figure it out without wasting more time. I have a cell with a UPC code, ex- 781052055704 I want to take another UPC code of the same length and put it in the same cell, separated by a comma. This is what I want...

I'm using VLOOKUP to match across 2 very simple tables of data: First few rows of TABLE 1 are: <TABLE style="WIDTH: 200pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=266><COLGROUP><COL style="WIDTH: 60pt" width=80><COL style="WIDTH: 140pt; mso-width-source...

I've got a macro which copies data from one sheet in one workbook into another sheet in the same workbook based on certain criteria with formatting changes applied: Sheets("Sheet1").Select Range("J" & CStr(LSearchRow)).Select Selection.Copy...

I am trying to select the cells that meet a couple of criteria, the value has to be greater than 0 and formatted as currency. I have tried the following with no success. Any suggestions? If cell.Value > 0 And Selection.NumberFormat = "$#,##0.00" Then 'do stuff End If

Hi, A value in a cell is "3,500". I convert all to text format and then remove the quotes. Removing the quotes causes the last zero to disappear, so the cell now contains: 3,50 Worksheets(gs_sheet).Range(sRange).NumberFormat = "@" 'text Worksheets(gs_sheet).Range(sRange).Replace What:=""""...

Hi all, New to the forum and also Macros. I am trying to write code to make a cell default to a negative value based on the text of another cell. For example: if the cell states "EXPENSE" then the offset(0,1) will be a negative figure when the numbers are entered into that cell. Any help...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi Everybody, Does anybody know if it's possible and what is the synthax for in the automatic format cells menu to : - force excell to align the sign - to the right close the number before ( -9.5 instead of having (- 9.5) - Automatically put a + before positive numbers (+9.5 instead of...

I have 2 list of numbers in a drop down list in a cell in Excel. The problem is Excel does not allow me to "type in" these values from the keyboard for the list that has numbers (but I'm able to type in the list that has "names"). I'm guessing this is because lists are "text" by nature in Excel...

How can I display a number as 123.45 to 123. If number is 123.50, display as 124. I just want to display whole number.

I have a userform and when you click the "Okay" command button, my spread sheet is populated with the numbers from the form but I can't get the number format correct. I've tried cell(x, y).number = so on and so forth but it doesn't work. I believe it's populating as a "General" entry in the...

I have columns of ssn and ph numbers that are not responding to special or custom formatting. Any ideas why? I am using 2007 and the file sent to me is Excel 2003 if that makes a difference. I am very new to Excel and can use all the help I can get. Thanks