type

Hi If I type "=-85.00" into a field in excel I get #FIELD ! If I type this on my other computer I get -85 I presume there is a setting I am missing Any help would be appreciated. John

Hello Now knowing the cause of "Type Mistmatch Error 13" How can i know which cell or different cells which gave me Type Mismatch Error 13 column (Z) contained Formula value ie =X2*Y2 . By mistake the cell in Column(Y) was typed with something else rather implementing the formula eg in cell...

Hello, I'm relatively new to access so thank you for providing any insight you can. I have a Combo box in a Form that lists a bunch of names. I have the source of this dropdown pulling from a table called 'names'. When a user clicks the dropdown in the Form and then begins typing - it...

I made a Querie: ActiveWorkbook.Queries.Add Name:="QueryTab", Formula:="let" & Chr(13) & "" & Chr(10) & _" Bron = Excel.CurrentWorkbook(){[Name=""Finost_OI_1""]}[Content]," & Chr(13) & "" & Chr(10) & _" #""Type gewijzigd"" = Table.TransformColumnTypes(Bron,{{""Date"", type date}...

hi, guys i'd like code works to consodilate data from multible sheets to one sheet i have sheets1,2,3,4,5 the data columns a,b,c,d in all sheets what i would be showing data in sheet5 but the column d contains brand is formula like this sheets5=(sheet1+sheet2+sheet4)-sheet3 and...

Finding last occurrence cell of a mu <tbody> Item Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY Action date ACTION TYPE PERFORMED BY 45685 2-Jun-2019 Submitted (Jansson [Requestor]) 4-Jun-2019 Submitted...

I'm using the current formula: =IF(ISNUMBER(SEARCH("Nature",A2)), "Y", "") to show whether a word (shown in cell B1) features in a set of meta tags (shown in cell A2). <tbody> A B C D E 1 Nature Ocean Sun People 2 Nature;Ocean;Outdoors;Water;Sky Y Y 3 People;Sea;Waves;Sun Y Y...

Hello, I would like to know how to create an IF query for multiple criteria. Basically I need to calculate commission based on the following criteria, brand type min margin if the type is used, then look at the sell price the answer to all of these will then need to look to know if what...

I have never seen this before. I have 2 files in a network folder and they both show available fund remaining for every project that my company has. One is from February, and I formatted it about a month ago so that as new available fund reports come out I can just drop them in there, PQ would...

I've gotten a list of post codes and their counties. This is how the data is presented: <thead> #EAECF0[/URL] , align: center"]Postcode area #EAECF0[/URL] , align: center"]Postcode districts #EAECF0[/URL] , align: center"]Post town #EAECF0[/URL] , align: center"]Former postal county...

Hello I am Getting Type Mistmatch error when using .Numberformat marked in Red Did I miss something here therefore am i getting Type Mismatch error or is it the wrong method that i've adopted Public Sub nmbrFormat() Dim rNos As Range, cellsRNos As Range Dim wsMis As Worksheet Set wsMis =...

So I have the below Macro code that is set to change a cell in column E to 0.00 if a cell in column K has the word yes. However, I'm unable to go-back (Ctrl Z) once the I type in Column K (Sometime I type yes & then I have to remove it change it but I want the cell value to go back to its...

Hi, So I have a column of data (10,000+ rows) which contain various codes assignedto the individual (Around 60 different codes). These codes situnder 5 different headings, but these headings are not contained within thedata set. My aim is to insert5 new columns with the row header for each...

Hello I would like to know how to do an index/match with multiple matches. Eg I would like to return 'date' from another sheet only if 'student ID', 'assessment name' and 'assessment type' also exactly match. I would be grateful for any help with this. Thanks Adam

Hi there Good morning I have a spreadsheet which has a few date columns and I wantto make use that however enter the date that it always shows in the same formatno matter how they type in the date. For example, you type 3rd March 2019 it shows as03/03/2019. Does any body have any ides to...

I don't know why I cannot remember how to do this...but... I have a time cell and I just want to type "1753" in the cell and for it to display as "17:53". How do I have it automatically add the ":" to that cell?

i need help how i can sum up this cell <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> Type SP: 90 DC: 20 PC: 22 (TOTALSUM) </tbody> Thanks.

Hello, I share a lot of generic code between my projects I load a module and it "speaks" immediately with other modules, enum's and type's... sometimes some specific module/enum/type is not on the workbook and I need to comment out a lots of line of code, so I thought to use some kind of...

I'm sure I've got some of the terminology wrong, but here's basically what I'm trying to do. I have a table of data with three fields I want to use in a chart: date issued, department, and type. What I'd like to end up with is months along the x-axis based on the date issued, a count of entries...

Hi, I have a table that we use to help schedule employees and want some type of warning if we double book them. It is setup as such: <tbody> A B C D E F G H I J K L M N 1 Name Job# Loc 6/25 6/26 6/27 6/28 6/29 6/30 7/1 7/2 7/3 7/4 7/5 2 John A X34 USA D D D D D D D D D 3 Joe V45 CAN N...