Search results for query: *

I'm looking for an easy solution to add a leading zero to a text string in excel 2010. There is the text string: N5^43'W it should say N05^43'W or S6^7'E should say S06^07'E Thanks

Hello, I'm not sure where I should start. I want to import only some of the values (based on a given value) from a comma delimited text file to an Excel 2007 sheet. The reason is I have over 1.5 million rows of data and Excel can only handle a little over 1 million rows.

I cannot figure this out. In column A 100 1001 324 542 562 And would like to place in B1 100, 1001, 324, 542, 562 Any help would be appriciated.

How do I create a sequential list from the values shown? The NA's will have generate a number as well if a condition is met elsewhere. I need to keep the NA's (just because). Thanks Cory Column A Column B Column C 3 8 6 4 14 9...

I have about 200 hyperlinks to make. The file name is is pic1.jpg, pic2.jpg, etc... is there a way to have the hyperlink automatically increment to the next pic number?

Hello, I have been trying to create a single list (sorted lowest to highest) of numeric values from 3 different columns and place it in a single column. I do not want to use any macros (VBA). Is this even possible. Place values from B,C,D into A. B,C,D might change so is it possible to...

Hello, I would like to have a gradient background for my spreadsheet. I can create a shape or text box with one, however I cannot select the cells underneath the shape/text box. Does anyone have any ideas how this can be accomplished? Thanks,

I have a chart that is using the N/A values for the axis labels. It is labeling the N/A value as zero. How can I format the chart so it does not use the N/A value?

I have searched everywhere, tried everything (except the one that works) and I still cannot figure how to change a #N/A cell to white, or any color with conditional formating. I tried ISNA, but I cannot get it to work. Any help would be great. Thanks.

Hello, I cannot figure out how to format a cell to a certain color with a simple IF statement. Example =IF(C3=4,Change C3 to Red,Do nothing) I would like not to use the conditional formating, macros, or VBA to accomplish this task. My ultimate goal it to change all cells within the entire...

Hello, If cells C:4 through C:? has numbers in it. How can I code a scatter plot to recognize C:4, Scan the Column C:C and find the last cell with a number in it. Then have the scatter plot update automatically from C:4 through the last known value in Column C. I cannot use any macros, vba...

Hi, Land Desktop Companion 2008 When I want to export points I get a message box that says "There was an error opening the format handler" then ldd gets fatal error screens and wigs out :( (closes) SP2 Installed, system top notch, etc....

Well it going to happen soon :(. Figure prefix files from 2007 and Description key files... Is there a way to transfer those over? Do not want to retype all of them!!! Thanks

Land Desktop Companion 2008: The dictionary will not work. There is only a hadfull of "A" words in the custom dictionary (custom.dic) file. How do I get the dictionary to default to the main dictionary. It will not recognize any word I just typed in this message. Grrrrrrrrrr.....

LDD 2007 How do you explode a 3d face? It needs to hold all the elevation properties. I want to import a surface from Microstation to LDD 2007. Microstations surface lines are 3d faces. Thanks

Here is the situation: I have a drawing with Photogrammetry data in it. Contours, Elevation location (an X with the elevation next to it), trees, etc... Is there a way to take the "X"(it is a block) with the elevation associated with it and turn it into a Land Desktop point, or create a point...

OK, this should be EZ for someone out there. Here is the problem: N 45-56-47 E need to look like N 45°56'47" E how do I use wildcards to pull this off?

How do you attach SID files in Land Desk Top 2007? I tried attach, imageattach, etc... NOTHING WORKS!!!!!!!!! 2006 worked just fine..

I installed SP2a and when I go to Dimenesion- -Style LDD Closes without any warnings. NOTE -THIS ONLY HAPPENS WITH DIMENSION/STYLE- So I installed SP1 and the same thing happens. Any fixes out there?????? 2nd time I have to reinstall LDD GRRRRRRRRRRRRRRR!!!!!!!!!!!!!!!! Maybe I...

When I export a group of points PNEZD (Comma Delimited) it places a space after the comma. My surveying equipment will not recognize this format. How can I export points without the space after the comma. (I know a word processor you can find and replace, but I don't want to every time I...