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...
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...
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...
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...
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...
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.
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...
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?
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.
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.
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.
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.
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.
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...
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
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?
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.