Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. goitc7

    Create web page that is always centered

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

    Create web page that is always centered

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

    Create web page that is always centered

    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...
  4. goitc7

    Need to test for 7 digit date in excel add leading 0 if needed

    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!
  5. goitc7

    Need to test for 7 digit date in excel add leading 0 if needed

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

    Need to test for 7 digit date in excel add leading 0 if needed

    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...
  7. goitc7

    Need to test for 7 digit date in excel add leading 0 if needed

    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...
  8. goitc7

    Need to test for 7 digit date in excel add leading 0 if needed

    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
  9. goitc7

    Need to test for 7 digit date in excel add leading 0 if needed

    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 !?!?
  10. goitc7

    Need to test for 7 digit date in excel add leading 0 if needed

    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...
  11. goitc7

    Need to test for 7 digit date in excel add leading 0 if needed

    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...
  12. goitc7

    Need to open file, reformat data and save as different file

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

    Need to open file, reformat data and save as different file

    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" +...
  14. goitc7

    Need to open file, reformat data and save as different file

    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 ...
  15. goitc7

    Need to open file, reformat data and save as different file

    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...
  16. goitc7

    Need to open file, reformat data and save as different file

    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
  17. goitc7

    Need to open file, reformat data and save as different file

    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

Part and Inventory Search

Back
Top