numberformat

I have a page for data entry that I want to automatically convert any data that is a percentage to a whole number (50% to 50 - not to 0.50). I am in the Sheet code (not the workbook) and I can't seem to get this to work. Data will likely be pasted by the user in bulk to a range (B3:H32) though...

Hi, I believe Range.Numbeformat is the property I am looking for. I have a cell with a dropdown picker. If the user chooses "Distractor" from the picker, Worksheet_Change triggers an Inputbox to open, asking what kind of distractor it is. We'll use "Gloves" for this example. I want the cell...

<code>On this page: http://msdn.microsoft.com/en-us/library/aa224873(v=office.11).aspx The example for NumberFormat goes like this: Worksheets("Sheet1").Range("A17").NumberFormat = "General" However the string "General" seems incorrect when you have installed a non-English Microsoft Office...

Hello, I know there are a number of threads dealing with this topic, but everything I have looked at seems to have the issue resolved at 'set numberformat', and that is not solving my problem, so I decided to post a new thread. I am working in access and excel 2003. I am using...

I'm using Excel 2003 and have copied values from Sheet1 to Sheet2, Sheet3... Sheet(n). If a value is a date on I need to keep the date format on all sheets. (MM/DD/YY HH:MM:SS) If the values is 0,1 or 2 I need to keep the values as is. If it's any other number I need it to be NumberFormat =...

Hello, I'm new at VBA and I could use some help debugging my code. I keep getting the error, "run-time error '13' type mismatch." Thanks. ' Converts 0.00 values to "-" characters '--------------------------------------- For Each c In...

Afternoon All, I ahvea tricky one, i have data that i am sorting and then copying in to a field that is used as a named range. Im running the code below in order to change the data from TEXT ot numbers. I know that the data is AlphaNumeric but i would 3 digit numbers for Example "10" would be...

I have a VBA module in which I need to add formatting to a number based on several criteria. (Excel 2003). If a record in the worksheet meets these criteria, the cell should be displayed as a right-facing triangle (U+25BA), the number and a left-facing triangle (U+25C4). I am able to do this...