Search results for query: *

Thank you all so much - I think I will try the 960.

OK. Thank you all. That seems straighforward. Is the best fixed width for today's monitors something shy of 800 wide? Maybe 780 pixels?

I am using Expressions Web and would like to create a web page that is always centered that would be the "container" for all other elements and then build a table on top of it to have the different sections i.e. top for title then navigation on the left and section in the middle and the bottom...

Hello all, Sorry for the delay in sharing the results. Putting it all together it worked! Used =DATEVALUE(TEXT(A1,"00-00-0000")) then pasted the value of this column to a new column and deleted the other two columns used to get to this point. Works great ... I cannot thank y'all enough!

Ah! Thanks Let me give this a try and I will let you all know

Skip, it seems like that should work. Then I can use the text to column routine, right? So, if I had the imported data in column D, I could use =TEXT(d1,"00000000")and then copy that down through the column. Next, to import into Access I need to get rid of the extra columns so I need to delete...

Hello all, Let me clarify ... I am not initially converting a date to text. I am importing a file from a handheld device. The column that contains the data that is the date is, to Excel just some numbers that end up, I think being formatted as general. If the number had a leading 0 coming in...

Hi PHV NO, that doesn't bring any joy! I have to convert to text to be able to add leading zero if needed and then changing the column to a date format doesn't seem to have any effect. Thanks

When I try the DATEVALUE formula (for instance in K1 for the text in J1) it shows the formula in K1 instead of the value of J1 converted !?!?

Thank you all. The reason I have been trying to convert the "date" import column to text is because the single digit months lose the leading 0 by the time it opens in Excel. So I was doing that to put the 0 back in. The DATEVALUE would be used after it is converted to text and the 0 added...

Hi, I have a handheld device that I download to Excel. The date column has to end up mm/dd/yyyy but when I convert the column to text I lose leading zeros for singe digit months. I am trying to use a macro to 1. convert to text 2. test for 7 digits and add the 0 if needed 3. then maybe...

I like it, thanks. I will do some tweaking and see what happens. Thanks again

Hi With your help I think I have it. The 24.50 is taken from raw time data ie 2450 and the H1OT is converted from the 10 and 11 column with this ... ' let's solve NumHours If strworkin.Substring(45, 2) = "00" Then NumHours = "00000" +...

Here is some code from the file I am importing 00000,0000000401,0000000002,0000000002,11,00800 00000,0000000401,0000000002,0000000002,10,01600 00000,0000000401,0000000002,0000000002,10,04000 00000,0000000402,0000000002,0000000002,11,00875 It will end up like this ...

OK, Thank you for your help. I have it reading a text file now. Today I will get a sample of my import file so I can work out the concatenation I need. I will have to read through it a line at a time and extract three or four pieces of information, remove some 0s and replace them with spaces...

Thank you for your help. I am trying the code and I get several errors, "Statement is not valid in a namespace". What do you think is the matter? Thanks again

Hi I need to open a space delimited timeclock file with payroll data and then reformat the data for import into into a payroll program as a txt file. Any help would be appreciated