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!

  • Congratulations Mike Lewis 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. techie131

    Excel Date format

    SkipVought That is what I thought too but even changing the format to YYYY/MM/DD did not resolve it. As it turns out there is a hidden apostrophe at the beginning of that data. So that is why I am opting for a macro to strip it out. Andrzejek Thankfully this only occurs on one company's csv...
  2. techie131

    Excel Date format

    Ok we have a workable solution. A macro was created with the following code. It removes the apostrophe at the beginning and the date shows properly after that. So the user just opens the macro excel file and than imports the data and runs the macro on the affected columns and resaves the excel...
  3. techie131

    Excel Date format

    Andrzejek I did the steps you suggested. Use the formula on a new column and than did a copy values only but it still doesn't convert the date to YYYY/MM/DD even if I change it from General to Date. Not sure what else it could be. I would prefer not to do VBA for this one as I have to show the...
  4. techie131

    Excel Date format

    Andrzejek you are correct following those instructions does give B2 45134. Now is there a way to remove the apostrophe or tell excel disregard hidden apostrophe so that column A is interpreted as Date instead of Text. We download this excel file so we can't change the way the data is...
  5. techie131

    Excel Date format

    Dhookom I tried that and it does not change the format
  6. techie131

    Excel Date format

    We download a file from a company site and the Column B always has date format as MM/dd/yy than the time. I have my region settings to set the date to yyyy/MM/dd. I can't seem to override the setting so it converts the date in Column B to yyyy/MM/dd than the time automatically. I have tried a...
  7. techie131

    MS Access Query

    Ok it is solved. Turns out one of the tables had been converted from linked to local so the data stopped updating and that is explained why the query shows different information than what the table was.
  8. techie131

    MS Access Query

    It has been awhile since I had to work on MS Access queries. My workplace has an access query that kicks out no data when it is run. An older version of the Access file which points to the same datasheet .csv gives out the correct information. Does anyone have anyone advice on how I can...
  9. techie131

    Laptop gray screen

    I have a Dell Studio 1535 and when you power it on it gets a gray screen. It will occasionally get a picture and will sometimes work if I open and close the LCD screen. It works fine if connected to an external monitor. Can anyone tell me if it is the inverter or the LCD screen itself?
  10. techie131

    Internet Explorer 7 Copy Paste not working

    Disabled all adds on even reinstalled the Internet Explorer 7
  11. techie131

    Internet Explorer 7 Copy Paste not working

    I have a computer that has Internet explorer 7 installed that does not allow the keyboard shortcut for copy and paste to work. CTRL C and CTRL V will not work at all. This only happens on Internet 7 not Mozilla or Internet Explorer 6. Has anyone run into this problem before.
  12. techie131

    Outlook closes with many emails

    The laptop has 2GB of memory and outlook does not appear to be using more than 100mb of memory according to the task manager. Also does anyone know of a way to restore open email sessions when you bring outlook backup.
  13. techie131

    Outlook closes with many emails

    I have this strange problem with Outlook 2007. Outlook 2007 will suddenly close down without any warning and close down any open emails I have as well. I did have about 30-40 emails open at that time. Could this be causing Outlook to shutdown.
  14. techie131

    Outlook 2007 search subfolders

    In Outlook 2007 if you select advance find the search of all subfolders is not automatic unless you select browse and search sub folders. Is there a way to make this automatic.
  15. techie131

    Barcode Scanning

    I have Windows CE running on a symbol 3090 scanner. I need application that will run on Windows CE so I can setup a prefix if certain data is scanned from a barcode. Does anyone know where I can get an application like that.
  16. techie131

    Outlook 2007 slow to move emails

    I have an user with a large number of personal folders between 1 - 2 GB in size. When she tries to move emails to these personal folders it does take some time for the actual move. I did defragmentation by moving the personal folders off her machine than back on than running the defragmentation...
  17. techie131

    Blackberry 9630 Bluetooth problem

    We have a new blackberry 9630 and no matter what bluetooth headset we attached to it. The person on the other end can barely hear them. Was wondering if anyone has experienced this problem and had a solution
  18. techie131

    Sony Vaio RS221

    I have someone with a sony vaio PCV-RS221 computer and they cannot access the recovery partition and they don't have a recovery dvd. Can anyone tell me where I can get a copy of the recovery dvd?
  19. techie131

    Excel file slow to open in 2007

    Ok I was able to determine the problem was with the excel file itself. I copied over all the data to a new file and it came out to a file size of 700KB. So there is something very large in the old file slowing it down.Look around the file but could not find anything that could explain the...
  20. techie131

    Excel file slow to open in 2007

    I have an excel file that is very slow to open and to use butonly in Excel 2007. In Excel 2003 it works fine. The file is fairly large around 12MB. Can anyone tell me what could be causing this slowness?

Part and Inventory Search

Back
Top