- Todays Excel challenge
I’m retrieving data from an Oracle database into an Excel spreadsheet, the first 12 days of the month display in the format mm/dd/yyyy the remainder of the month displays correctly dd/mm/yyyy. I’ve tried all sorts of cell formatting without success. Does anyone have a clue what the problem could be?
Thanks in advancePosted 8 years agocbrsydMember
Not had this with dates but had the same issue with numbers. Some numbers in a column came across as numbers and some as text and the format option wouldn’t changed the text cells back to numbers.
Got round it by using the left and right text functions to split the cell contents up then the concatenate function to “reassemble” the numbers stored as text. After that was able to convert to numbers.
So I would try changing the format of all dates to General (which should display as a number)then convert them all back to the date format you want or try multiplying every cell by 1 to convert to a number then changing to the date format you want.Posted 8 years agomuddy_bumMember
I’ve seen this before with foxpro data.Posted 8 years ago
The standard format in the data is mm/dd/yyyy fixed by the database but the regional settings on the local machine are dd/mm/yyyy. The answer is to force one format or the other in your importing.
Don’t know how you do that though. Is the data linked, copied and pasted, exported and imported?
The topic ‘Todays Excel challenge’ is closed to new replies.