converted

I want to update a column format to general instead of a date. Can I retain the date instead of the date being converted into a number?

Hi I'm writing some code to convert a SmartArt organisation chart to shapes and then extract the text. The converted rectangles don't appear to be msoShapeRectangles though. They are called Freeform xx which isn't a valid mso type. Any idea what they might be?! Thanks Chris

If someone sends me a database, with one cell with an entry such as "1234 Smith St, Apt 5" Can it be converted to two cells, one with "1234 Smith Way" and another with "Apt 5" Thanks in advance

I'm doing a very simple report. I have a bolean field that I converted to 0 and 1 using sql CASE. In the virtual view is defined as an Int. When I create the Crosstab, the values column is the column RevSup that I converted to 1 and 0. For some reason is not summing all the records that it...

Hi, this only happens with numbers that look like a date: I have data like this: 1 to 9 10 to 12 13 to 15 17 to 19 Now i need it to look like 1 - 9 10 - 12 13 - 15 17 - 19 Problem is with the first two, get converted to01-Sep and 10-Dec this is what ive tried: Range("A2:A1000").NumberFormat...

I know this is a big "ask", but I need some help. What I need to happen is all the data on the "raw data" sheet needs to be converted to the format on the "converted data" tab. I can of course do this manually but I was looking to do this with a macro and run it from a button on the "raw data"...

Hello, I had a question about what a particular time conversion is called if it's called anything at all. Example: The formula I'm using is =((A2*60)+B2)/60 If your children did homework for 4 hours and 30 mins. That can be converted to 4.5 or 4.50 If your children watched TV for 1 hour and...

Column A contains urls, need vba module to download the images from these urls/hyperlinks to desktop. The below link has been converted to hyperlink in excel <tbody> http://i723.photobucket.com/albums/ww237/sukkhi2/Stock 23/Stock 23 Remaining/26ALPHAZ340_zpssoxAB3fbh.jpg </tbody>

I need to replace a string like below: IpArId to be converted as Ip_Ar_Id Wherever the upper cases identified in a string to be prefixed with "underscore" ("_").

hey guys i need to convert some scanned pdf files to excel. These are complex file containing tables and whatnot so they can't be converted with these simple online websites. It would be a big help if Anyone could point me to right direction

Hi, I am trying to make an iterative physics macro, but I have problems figuring out whats wrong. I have had success with a similar macro on another iterative macro earlier. When I try to debug and run cursor to "P1" line, the formula goes blank and the debugger just stops... Macro: Function...

This is a slightly weird questions, but I need a decimal converted to a fraction a certain way, similar to the fractional number formatting. I'm guessing this will have to be done in VBA Here's an example of what I'm looking to do: I have a cell that is always rounded to the nearest 0.5, I...

I posted this this am but it is gone. I have recently done several large projects. Since many of our sites do not have full Excel, I had to convert some of the workbooks to be able to work in LibreOffice Calc. The folks that are using the Libre versions will save the workbook as an XLSX (or...

Can decimal values be converted to whole numbers? 0.39 0.28 0.20 0.40 0.29

i have a dataset which can be converted into a graph how do i get an overlapping graph showing the average of the highs and lows 1 17.02 2 16.42 3 16.54 4 16.11 5 17.08 6 17.3 7 17.24 8 -8.86 9 -10.64 10 -8.34 11 -4.56 12 -0.86 13 0.02 14 2.16 15 3.78 16 4.28 17 1.3 18 1.3 19 0.9 20 4.3 21 4.7...

Hi all, Long time lurker and first time poster. I regret to make my introduction one where I ask (beg) for help but am at a loss achievable results. I'm compiling some football stats (not soccer). For anyone not familiar with football you have 4 downs to get a min. of 10 yards to achieve a...

I have some values like this: Cluster_0052.001.1 I want the numeric portion. I used a formula that worked for most of them =RIGHT(A2,LEN(A2)-8)*1. However, there are about a 1000 where this didn't work. I even tried in VBA and they wouldn't convert (i get a type mistmatch error): For i =...

Hello all , Ive just had a macro VBA work written for me by a very trustworthy source . My excel worksheet was quote "converted your dataset to a table in order to get the most efficiency out of the calculations". Im extremely happy with my new macros but i have no idea how to change my...

Good Morning, I have a drop down list on my form of the combobox type. Now my list is getting longer i am having to drag the side bar for the names that are out of view to then be shown. Can this be converted so it can scroll or please advise otherwise. Dragging it seems old fashioned & need...