typed

About four months ago I began to notice that if I typed too fast, characters were omitted in the text I typed into the reply window on the Excel Questions forum. And I am experiencing the same problem as I type this thred. It also resists highlighting with the mouse pointer when I try to...

<tbody> ID CODE OUTPUT 001 AM AM,AS,PA 001 AS 001 PA 002 ZE ZE 003 RO RO,IH 003 IH </tbody> I require formula for the above data, I have typed the output that I require, I require formula the output column Thanks, Ron

If I want the contents of cell B3 to be put into cell A1, I type in cell A1; =B3 However it isn't doing that. I end up with =B3 typed in cell A1. Any suggestions. Thanx B

In a financial spreadsheet I have some ranges where user can type in financial values with 2 decimal places. But I want them all be automaticly rounded down to zero decimals. This should happen after the value has been typed in. Examples 1,250.23 --> 1,250 1,250.81 --> 1,250 Is there a VBA...

Is there a way to make excel ignore formatting of data cells so that my formula will work. The data is typed into the worksheet, however the format is General. My formula won't work unless the typed in value is preceded by apostrophe. Is there a way to solve this problem? My formula is...

I have a large Excel document with worksheets for each new day. Yesterdays file updates were added in the Notes column (DZ) of that days worksheet (5.14). Today's worksheet is 5.15 and again the notes column is DZ. I'm looking for a formula that will copy the text from yesterday's notes (the...

I have a hyperlink that I've typed into a cell, but it doesn't work like other hyperlinks I've typed in cells. What steps do I need to complete to get it to work as a hyperlink?

Hello, I have a workbook where users are required to enter values in Range A2:A1000. If the value entered in the range is less than 100, I'd like the value to be automatically multiplied by 2080 in the exact same cell where it was typed. If, however, the user enters a value greater than or...

So this may be dumb but I type in January and then auto fill down and get to December. I think use that as a month ref in an equation =month(a1) where January is typed and I get an error. What do I need to do so that I can type a month and have excel know that when I use the month function?

Good day, I am looking for a formula to look for a partial number within a column on a different sheet. Some of the numbers does contain letters for example H1007 or S0436, but they typed it in as 1007 and 436. The only other problem is the numbers are within a description/sentence. Please...

What I need is in a workbook with 135 worksheets each has custom name, I want to enter same worksheet name in cell C1, for example "C1 of worksheet Alex to have Alex typed" is there a way in VBA to do at once.

Hi, I am trying to combine the functions IF(), AND(), and LEFT() in a formula, however excel keeps saying #VALUE ! or #NAME ? instead of calculating the formula. This is the formula I typed, please help me find out what the problem with it is. Thank you in advance...

Our accounting manager has multiple Excel 2016 workbooks open at a time. She regularly will be working in one and then look up after typing (using the 10 key on the keyboard) to discover that nothing she typed is in the visible spreadsheet. If she looks at her other open workbooks (bringing it...

Hi all, I'm having a strange problem. I have a formula subtracting one cell's value from another - the resulting number is incorrect by a very small decimal amount (like 1*10^-14). The initial two numbers were typed in so they should be exact values. Anyone know what is going on? Screenshot is...