I'm not the best at Excel by any manor of means. I can insert data and do the simple stuff with the formulas. I'm a web designer and devloper so I mostly use excel to arrange and structure data for upload into a database. I have a problem with this. I have 4 data columns in a spreadsheet which have date formatting on them, what I need is to take the values from these fields and combine them with data from other columns to create my import statements. When I set up the statement for a field which contains the following date: 02/02/2010 I get it showing as 40211.
Can anyone tell me how to keep the data looking formatted but remove the actual cell formatting?
The data I have is over 22,000 rows so I can't manually change all of this. Any help will be much appreciated.
Bookmarks