o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

cell rounding of value automatically -

Hello
i am working on this worksheet, and it is rounding off the value in certain cells automatically.
e.g. if i have a value 2.98 in cell c3 and i make the value of the cell in question say c56 =c3
it gives a value of 3

actually i discovered that the cell does not like any fractional number, if i directly try to input 3.1 it rounds it of to 3

 

cell rounding of value automatically -
Hello i am working on this worksheet, and it is rounding off the value in certain cells automatically. e.g. if i have a value 2.98 in cell c3 and i make the value of the cell in question say c56 =c3 it gives a value of 3 actually i discovered that the cell does not like any fr

C++ automatically rounding off values -
how to resolve the case of c++ rounding off values, for example: cos(6.2832) i get 1 instead of .99999 and 0.1 being only 0... what should i do

Excel within vb6 -
I am working on a program that opens up excel in vb6 and moves the capures the contents of a specific cell, what I would like to do ie automatically select the next cell in the sequence(ie from d4 to e4) without selecting the next cell as e4. some thing like first cell +1 ? is this p

Selecting a cell automatically -
Hi all. I need to select the content of a cell automatically in a datagrid(without the user clicking in the cell) and I can't figure out how to achieve this. I'm runing a 'Find' function on my recordset to which my datagrid is associated to and after the recordset has found the r

keep from rounding -
I have some formulas outputting to a text box. The numbers keep rounding up. How do I stop this?

Rounding Numbers in VB -
are you rounding or just truncating? your example of 100.956 should round to 100.96 not 100.95 serge's code rounds which is not what your example shows

Inserting Text into a DataGrid Cell -
Hi, Does anyone know how to insert text into a DataGrid cell automatically. What I'm trying to do is have a users account name entered into the first cell when I click to enter data into a new row. I currently have a DataGrid setup so that when a customer account is selected it o

Help: Rounding problem ! -
Hi, I have an application and that give me rare rounding problem. The statement I use to rounding the value x = x + round((w * y), 2) it loop through 4 records, only two record get rounded corrrectly and the other two is not, I have no idea why. Original value Aft

Get Past the 7 Nested IF limit -
I need to implement a more than 7 IF nested Statements in a Master Excel sheet I am creating. It is a Tolerance Table that I need to put several times across the sheet and across the book. I know it can be done in VBA but I am not an expert in VBA. Of course I tried to write the who

[2005] How to autoexpand a combobox cell in a DataGridView -
Hi, I have an unbound DataGridView with 3 columns. The cells in Column 2 are comboboxes. When a user clicks on a cell it first selects the cell and then they have to click again to expand the combobox. Is there any way to automatically have the combobox expand when the cell is se

Basic MS Excel 2000 Formula Question -
Ok, I'm trying to prompt "text" to print in another cell as a result of a nested-IF formula in a different cell. Ex: =IF(B11>B16,SUM(B11-B16)*B10,IF(B11<B16,SUM(B11-B16)*B10,IF(B11=B16,"$0.00"))) This is the formula I'm using in cell B17 to calculate t

help my numbers are rounding off -
i'm doing a order form, they only problem i am having is my output, all the numbers are rounding off instead of showing decimals, here is my code if someone wants to look at it and tell me what i'm dong wrong, thanks.

Rounding Numbers Within A Textbox -
Hi, Im fairly new to vb.NET, The problem I have is that I want to round a number down instead of it being rounded up. I want to round 10.389 to 10.38 instead of it rounding to 10.39, is this possible? thanks in advance.

Rounding Up in VB -
Does anyone know how to Round Up in Visual Basic. In Excel, you would type in a cell "=ROUNDUP(NUMBER)". But I can't figure out or find this anywhere in VB. Thanks, JEFF

How2change cell height (flexgrid) at runTime -
I want to know the way to change the cell height in the MSFlexgrid. Actually I set the word wrap property of the grid to true. In some cases the total width data in the grid gets more than the cell width and hence I'm not able to view the full data. Can something be done so that

Fill in the Date & Time automatically. -
Dear all: I have a worksheet which contains a column for the CURRENT day and time. What I would like to do is to have Excel automatically fill in the cell with the NOW() value upon selection of the cell. And I would like to confine this trigger to the entire A column only. Would

stop rounding up -
I have some formulas outputting to a text box. The numbers keep rounding up. How do I stop this?

[Excell] Input date in cell when another cell reaches 1 year mark -
This is, Im sure a very simple question, but since I know nothing of VB, I need help. Here goes... When the date in a cell (C3) gets exactly 1 year old, I want to automatically have another cell (D3) updated with todays date. Subsequently, the next year, when (D3) gets 1 year old

Help!!! in data grid Programming -
Hi friends I am create a project in which I am using data grid. I want to perform following function in the datagrid. In the cell I should not be able to enter negative value whenever i entered a value in one of the cell of a row of a data grid it automatically chnage

[2005] keypress , keydown event in datagridview -
hi all i use a datagridview to enter data and then save in table.i have some problems as below: 1- how can I active some shortcut keys like shift+enter , alt+tab,ctrl+tab and .... when control focused in one cell but is not in edit mode, 2- how can i prevent leave one cell without d

Very basic help needed -
I have an excel spreadsheet for my accounts. I want to enable my spreadsheet to automatically repeat figures entered into one excel worksheet into another excel worksheet in the same work book. Example: Sheet 1, Cell A1 = 10 I want, Sheet 2, Cell A1, to automatically updat

Silly question (Rounding) -
Have searched as always but it appears all the rounding done if for numbers like 10.34354 etc I need to round off to the nearest 10 but not least, example 10 would stay as 10 11 would be 20 3 would be 10 22 would be 30 Thanks in advance

Round function Question -
Dear all, I have a question about round function in VB. General Speaking, the round function is quite simple: round(10.123567,3) will return 10.124 which I believe it is using half-adjust rounding method. But right now, I need to have a rounding method function to help me rou

Rounding Problem -
Im using Visual Basic 6 and access 97 When i put a value in the textbox, for exemple 0.5 when writes this value in the database table apears 0. I think its a rounding problem, how can i solve this problem? Thanks in advance!

Problem with rounding a number! -
In real life, When we try to round a number, let say 3.825, up to 2 decimal points, the answer is 3.83, right? Unfortunately in VB .NET, the "Math.Round" method & "Decimal.Round" method, round number like this (Read the remarks I quote from the Help file m

[2005] DataGridView: cell edit/change -
i use CellBeginEdit and CellStatedChange.. all i want to happen is when i type any character in the current cell. it will automatically appear a messagebox and will say: "You type:" & the content of current cell

Datagrid - auto expand column based on text length as I type in the cell -
hi all, I am wondering how to automatically expand the column width of a datagrid As I am typing in in a cell. I know can do this through a a button click but what i want to do is trigger this to occur after every key stroke in a cell. How do i do this? thanks Steve

blank cell to activate selection of a check box -
hi, do you know how i can make a check box automatically selected, after a certain condition is fulfilled, i.e. if i have an empty cell, i would like the check box unselected, if i fill in the cell with text, #s, i would like the check box checked. I am talking about a check box from

Next Cell -
Hello, I have a for each that moves from cell to cell in one column. And what i want is, when the for each is in one cell i want to know what is the value of the cell underneath, because if is a determined value i have to block the cell where the for each is placed. Thanks

Can Excel automatically trigger an email -
I have a great Excel spreadsheet that gives me warnings of critical dates by the dates changing color. I would like to have that color change trigger an email to the responsible party. For example: Cell A1 has the person's name...lets call him Y.Zass Cell A2 has the critical da

[2005] Reading an XML File into an array, please help!! -
Hey all, I have just managed to get my sudoku game saving into xml files like this... <?xml version="1.0" encoding="utf-8" ?> - <Sudoku> - <Row> <Cell>5</Cell> <Cell>4</Cell> <Cell>8</Cell>

MSFlexGrid problem please help -
I want to automatically highlight a certain cell whenever a user clicks on a specific cell. How do I do that? I can change the properties of the selected cell no problem by using MSFlexGrid1_EnterCell() and MSFlexGrid1_LeaveCell(), I can also change the value of different cells usin

setting focus to a particular cell -
i have a macro running from a particular cell, it will run a script however I need to register the cell reference of the cell I clicked on on if the macro is running from cell S6 then the macro would need to make cell S6 the activecell, irrespective of which cell they were in prior

VBA Excel 2000 -
Two questions... 1. I have an application that downloads information from a sensor and places it into the active cell, then automatically moves down one row and awaits the next measurement. How do I get the entire row it is on to be shaded or color filled, etc. 2. I want a macro

Easy date/time rounding Q. ***RESOLVED*** -
Hi I'm trying to find the most efficient way of rounding time values to the nearest hour. Eg "19:41:00" should read "20:00:00" Any pointers anyone? Thanks in advance.

Rounding numbers to 2 decimal places - how to (Rounding) -
I am returning math to a variable (and/or a text box) BUT I only want to have two or three decimal places, that are rounded off. I cant figure out how to round them. I've tried setting text box properties, calling 'as currency' but I dont know what else to do. Thank you.

Rounding off numbers -
Hi, guys, Im creating program that includes number... but i find it difficult when it comes to money.. can you give me a sample code that will convert the result into a money(like $125.75) if the answer is 125.7657 it will automatically round off it into $125.77?

Hundredth rounding in Euro Conversion -
Using Double variable to store numbers from math formulas, I'm not able to get the correct rounding from national currency to EURO. That is, when the result is, for instance, 37.42500 I should have my variable (formatted with ##0.00) equals to 37.43 . Instead, I get 37.42 that is wron

2 decimal scan and re-display -
can anyone show me how to scan a textbox value let say if someone enter value : 12.123 automatically or immediately the value will be set to 2 decimal places like 12.12 Note : No Rounding ..... Thank you I will be waiting immediate respond

Rounding to nearest 25,000 -
This is not an ordinary rounding issue. Here's what I need to do. I have to round any number up to the nearest 25,000 increment. For example: 124,698 would need to round to 125,000 126,125 would need to round to 150,000 1,278,189 would need to round to 1,300,000 Anyone k