CSV File With Measurements - Number Not Recognized
Mar 4, 2013
I have a .csv file with measurements. I can open it in excel, and have succeeded in make 3 separate columns from it and save as an .xlsx file. But the problem is I still can't do calculations with the data. it are all values from a form like "-3.44e-07" but excel recognizes this as text. I don't have a green triangle in the corner and multiplying by 1 doesn't work.
Apparently i can use them as numeric values in MATLAB, but I don't know how to do this in excel. And I have 9 files like this, each containing 3 columns and 600 rows, so changing all the cells one by one is no option.
I use the dutch language version of excel so I hope I translate the specific names of things in excel correctly.
View 9 Replies
ADVERTISEMENT
Dec 26, 2012
i have a number (%) in the cell B3, which excel doesn't recognizes as a number. Is there anything i can do "excel-wise", instead of manually rewriting the number in the cell, for excel to recognize it as a number. Changing it to a "number" or "percentage" in the cell format doesn't work.
View 5 Replies
View Related
Jul 31, 2014
I have a column of figures in a file sent to me recently which are dates but for some reason have been reversed eg 20140321. This is 21st march 2014. However I have tried formatting the number as a date (as we would normally see it in UK eg 21/03/14 or similar) and I cannot get Excel to recognise it as a date - I just get a long row of asterisks. How do I get a recognisable date sequence?
View 6 Replies
View Related
Feb 18, 2013
I need to convert the following into radians:
65 feet/1 second * 12 inches/1 foot * 1 Radian/8 inches
I know the answer which should be 97.5 radians. It's just getting the right formula in Excel.
View 3 Replies
View Related
Feb 2, 2009
I need to convert measurements with (',") symbols attahced to them. See attached cells. Excel does not like the symbols and I cannot figure out a way to have it convert the values into tenths of a foot. For example, from the list below I need to convert 7'2" to 7.17. I have years of data. How do I do this?
7'2"7'1"7'0"6'11"6'10"6'9"
View 9 Replies
View Related
Sep 24, 2008
I'm an excel novice. I am trying to create a chart that assigns a range of foot measurements to each shoe size, but the data I am working with has only one measurement for each shoe size. Example: The data I have says:
size 7 = 250mm
size 7.5 = 255 mm
size 8 = 260 mm
So I want to create a formula, so the chart reads something like:
size 7 = 247.5mm - 252.5mm
size 7.5 = 252.5mm - 257.5mm
size 8 = 257.5mm - 262.5mm
I'm using ms excel 2003 on windows vista
View 2 Replies
View Related
May 30, 2008
I would like to use Excel as a measurement device. I have an inexpensive digital microscope that will store sequentially numbered pictures at the click of a button. I am then going to import the most recent picture into Excel and place a grid of transparent rectangles over the picture to serve as my ruler. Would it be possible to continuous update the Excel workbook with the output from the digital microscope?
View 7 Replies
View Related
Feb 4, 2014
This is an example of my data, lets say they are heights of trees. The number is the tree individual, t2 is the age of the tree, height_t2 is the height of the tree at the age t2, and t_ current is the age of the tree individual at present/current. I would like a formula for the t_current column that will pick out the current age of the tree individual and apply it to the age years previous. i.e the t_current age should be repeated for each height measurement for that tree individual, i have filled it in as an example.
Numbert2(age)Height_t2t_current
11236
12486
13706
14836
15926
161006
21286
[code]....
View 3 Replies
View Related
Dec 12, 2011
I have a worksheet used for scheduling. When a members time is updated, it updates the counting cell for that time by subtracting 1 (thats simplified, the forumla is more complex than that).
I have five teams and five workbooks for each team to do it's own scheduling. In just ONE workbook, the Worksheet_Change() event has stopped executing. It's fine in the others. I renamed the workbook to archive it then put another workbook in it's place and now that one works just fine.
The workbook that I've archived, I hate doing that not knowing what would cause the Worksheet_Change() to stop being recognized. There is no code on the sheet or related to the sheet that would stop it or cause events to be cancelled.
I wanted to know if there is some secret keystroke combination that may have been inadvertently clicked that would cause events to firing or stop being recognized?
View 4 Replies
View Related
Jan 10, 2008
I have created an Excell Add-In file (.xla). I just can't seem to get the procedures to be recognized and/or run. I have even created a custom menu based on the following tip: http://www.j-walk.com/ss/excel/tips/tip53.htm
When loading Excel will add the menu to my main tool bar. What is frustrating is that when trying to run one of the subroutines from the new menu item, I constantly get "The macro 'spreadsheetname.xla!macroname' macro cannot not be found'
I've checked the security settings and have verified that all add-ins are to be 'trusted' and I've lowered macro security to low. All of the subroutines have been declared as public as well. My suspicions are that there is some setting somewhere that is causing issues, but I just can't seem to think of what it is.
View 5 Replies
View Related
Apr 30, 2014
I have a system that exports start and finish times into a single cell as text (eg 9:30 AM - 7:00 PM)
I am trying to do a simple count of how many shifts start before 7:00 AM, or finish after 6:00 PM, and am using the text function to extract the individual time into another cell.
My problem is that i cannot get this cell to be recognised as a time instead of text? I do a simple "is this cell less than another cell" but it tells me no, even though the time is 5:00 AM.
See attached: Text not recognised as time.xlsx
View 1 Replies
View Related
Aug 3, 2006
I defined two custom buttons in Workbook_Open() function:
Private Sub Workbook_Open()
Dim cb As CommandBar
Dim ctrlInit As CommandBarControl
Dim ctrlComp As CommandBarControl
On Error Resume Next
Application.CommandBars("Project").Delete
On Error Goto 0
Set cb = Application.CommandBars.Add( Name:="Project", temporary:=True)
With cb
.Visible = True
Set ctrlInit = .Controls.Add(Type:=msoControlButton, temporary:=True)
With ctrlInit
.FaceId = 68
.Style = msoButtonIcon
.Caption = "Retrieve Template Types"............
In Module1 I must to turn ".enable" properties to Turn, but Excel don't recognize these variables there.
View 2 Replies
View Related
Aug 13, 2008
I am exporting data to Excel from a 3rd party application - the bulk of which are date entries. For some reason they do not come across as date fields in the cells, and you need to double-click on each cell to correct it. For instance if I try to filter the dates straight after the export to Excel, the cell entries are not recognised.
Anyway, I managed to get around this by running a macro on each column, e.g. for column C:
Columns("C:C").Select
Selection.TextToColumns Destination:=Range("C1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=True, FieldInfo _
:= Array(1, 4), TrailingMinusNumbers:=True
This only works however if there is at least one entry in each column. Is there a way of telling Excel to skip that column if it is empty
View 9 Replies
View Related
Oct 16, 2006
I created in module custom toolbar with a button, see the
Option Explicit
Public ctrlGUI As CommandBarControl
Sub CreateToolbar()
Dim cb As CommandBar
On Error Resume Next
Application.CommandBars("Cust").Delete
On Error Goto 0
Set cb = Application.CommandBars.Add( Name:="Cust", temporary:=True)
With cb
.Visible = True
Set ctrlGUI = .Controls.Add(Type:=msoControlButton, temporary:=True)
With ctrlGUI
.FaceId = 3205
.Style = msoButtonIcon .............
View 5 Replies
View Related
Nov 17, 2006
The following simple formula was written in Excel version 97. when I try to use it on a newer version (03) it does not seem to recognise it as a formula? =IF(F66="yes",1,IF(F66="N/A",1,0))
View 2 Replies
View Related
Jul 27, 2007
Hopefully this isn't too vague, but almost every project I've worked on so far has not recognized Public variables in all modules. I've constantly been searching for exceptions to this rule that could be contributing to this issue but haven't been successful.
I have read a million times that declaring a variable as Public makes it visible to all modules and preserves the value throughout. I've also read that if you edit code or reset your project, the values may be lost. I also know that if you try to use a variable before you give it a value (or for object variables set it = to something), it doesn't have a value yet. But all this applied, I'm still not getting Public variables to be consistently recognized or stay with the value I want them to have throughout the lifetime of my project (while the workbook is open)
My specific current issue (one of many so far) is that I have 4 command buttons within a worksheet object. Each triggers a different group of procedures, some of these are user forms. In the first button, I create two worksheets one to contain the current fiscal period "Options" the other for "Summary" of all the totals etc... (all financial data). In this first userform, triggered by the button, I allow the user to name these worksheets: like Summer2007Options or Summer2007Summary and I declare these publically as object variables OptSheet and SumSheet. These variable names and sheets are recognized for the next 2 buttons but now that I'm on the fourth, I have object variable not set errors when I try to refer to this variable.
View 9 Replies
View Related
Mar 11, 2008
I have a code that runs when I open the workbook. It asks if this is a new quote, if it is it should then open userform1. The problem is that sometimes when I click yes I get a "Path/File access error" popup, and then a VBA error box with "Run-time error '75' Could not find the specified object".
When i debug, it highlights the line "userform1.show"
IF i end, and then run it from within VBA it will then run fine.
Sometimes when I open the workbook it will just crash excel, and when I reopen it, it runs fine.
Simple code -
Sub Workbook_Open()
answer = MsgBox("Is this a new quote?", vbYesNo)
If answer = vbNo Then
Else
userform1.show
End If
End Sub
View 4 Replies
View Related
Dec 30, 2013
I have a Dynamic Named Range (Entries) that shows in my Name Manager...but is not being recognized in formulas.
The range is defined with a standard DNR formula, and selecting the code in Name Manager highlights the Dynamic Range.
[Code].....
But, when I use the NAME in a simple formula, I get an error. (#NAME?)
[Code] .....
View 6 Replies
View Related
Nov 8, 2013
I copied some columns of dates form a website into an excel workbook. Unfortunately excel does not recognise the text and therefore I can't sort the columns from oldest to newest.
I have tried the operations here [URL] as I though spaces might be the problem but with no success.
View 5 Replies
View Related
Apr 23, 2014
I have two text boxes on my sheet that I am using as a log in sheet. I am not sure what triggers them but they stop allowing me to type in them to log in and instead are recognized by excel as pictures and ask me if I want to format them. I have fixed them in the past by deleting them and adding new Active X text boxes to the sheet but then after a while they turn back into pictures.
By the way the text boxes have been named T1 and T2 and are used in VBA behind the scenes to determine if the details that are typed into them match existing accounts.
View 2 Replies
View Related
Jul 10, 2013
I'm trying to query Access for some data. One of the fields I need to grab is called MOD, which also happens to be a VBA function. How do I get Excel to recognize MOD as a field name instead of a VBA function? (Renaming it is not an option)
Code:
stSQL1 = "SELECT MOD FROM CST_ClaimbyLop WHERE CoCName='" & myCST & "'"
View 2 Replies
View Related
Jan 29, 2014
I have a file that I save with a new version number each time I make major changes. The file name currently is: "Telephony Equipment Inventory v26 (Summary).xlsm". The "26" is the variable number. give me the vba code to ensure I open the file with the highest version number?
View 6 Replies
View Related
Nov 14, 2013
I am trying to get my array formula to recognize the text selected in my data validation cell. The formula worked perfectly until I decided I wanted to try and use a data validation list to eliminate spelling errors. Even though the text I am trying to recognize in the cell is exactly the same, because it is in a data validation format it no longer works. Is there a way I can modify my formula so it works? Example below...
formula: {=SUM((A2:A109>DATE(2013,10,31))*(H2:H108="Joe Blow"))}
A2: 11/2/2013
H2: Joe Blow (chosen from a data validationi list)
The result of the formula should equal 1 in this example, or more if the same criteria occurs more than once within the range of A2:A109, and H2:H109.
View 7 Replies
View Related
Jul 31, 2014
I have an excel database where I register cases. I have in it a button that creates a folder with and ID nr that is in column A (I create new ID nr in the next row, when I press the button it will create a folder with that ID nr and inserts a blank word document in it). We have a template that we copy to the folder (depending what type of case). The idea would be that once the template is filled in and ready to print, It would take the values from the ID nr and a reference number a few cells to the right. Is it possible to tell excel to open the word document in the folder and create a PDF version with the ID nr and reference number. (there are only 2 templates, so the macro would have to look for one of the two in the folder) The names of the templates are: "Standard" and "Other". I guess the best way to start maybe this would be that I select the cell with the ID nr and then press a macro button to have this done. One thing that needs to be done, is to put a copy in the same folder and another in a second folder called "Binder" in my documents folder.
View 1 Replies
View Related
Apr 12, 2013
I have a column of dates that are not being recognized as dates unless if I manually select each cell and press enter. For example the cell value is "Jul/13' and isn't recognized as "01/06/2013" until I select it and hit enter. How can I get around this?
View 8 Replies
View Related
Jul 10, 2009
In order to get inventory data from our Incode database, I've been creating an output file with the extension .IRP Thinking that excel would not bring in this data from the .IRP file directly, I would then create a txt file of it with notepad. I've recently discovered that I can bring it in directly from the .IRP
The file being created is in this format:
IN Stock Status Report - 6385.IRP
The number portion, 6385 in the name will vary everytime I generate a new report. However the text portion will not.
Currently, I've recorded a macro the bring in the data to my excel spreadsheet.
But it will only bring in data for the set filename.
View 13 Replies
View Related
Dec 18, 2011
I am needing so I did it as a picture. (Please assume "Day 1" is A1)
View 7 Replies
View Related
Nov 8, 2012
I'm trying to make a simple chart, which maps the value of an investment fund over time. I wanted to use the new 'Table' feature within Excel 2010 to format and maintain the formulae within the Table, and the 'Header' for the table contains the date, which is not at regular intervals.
If I opt not to use the Table feature, I can create a line-chart with ease, and Excel recognises that the Dates are indeed dates and plots the graph correctly. The minute I convert over to a Table, the Date headers are no longer recognised as dates, and are instead plotted as if they were text, at regular intervals.
I've tried multiplying the Date Headers by 1 to force them back to true Dates, but this still does not work. I've also changed the setting on the horizontal axis to Date axis rather than automatic, but still no joy.
View 1 Replies
View Related
Jan 10, 2013
I am running Excel 2007 on Windows Vista Business 32 bit. Recently I have noticed that if I enter a formula into an empty, unsused cell, it is recognized as a formula. If I modify that formula, it is then recognized as text and does not work as a formula. The only way I can get the cell to recognize a formula is to delete the cell and start over. This same scenario does not occur on previously stored workbooks. I have checked all of the flags that I know about, including the Options function.
View 3 Replies
View Related
Nov 20, 2008
Here I would like to get your valued guidance for the usage of "IF" formula. I am having two sheets one is new XL-1 and other is old XL-2. I want to have a item number from the old file corresponding to the same item descprition in the new file. I am attaching the snap shots of two files which is more explanatory than describing in words here.
View 2 Replies
View Related
