From our invoicing program I exported some data in excel file. All fields seems to be in general format so I had to convert column which contains prices in numbers. OK. But the problem is in the column which contains dates.
Dates are exported in the following way: D.M.YYYY (example: 1.2.2007). To be sure that in this column dates are in the proper format (and I know they aren't because I tried to manage the data with PivotTable) I changed the format of the columns to display dates in the following way: D. MONTH YYYY (example: 1. February 2007). And after that nothing happened!! "Dates" remained as they were before: 1.2.2007
BUT!! When I selected (clicked on) one of dates, clicked in the formula bar and pressed Enter, the date got the right format: 1. February 2007 . Boh?
My questions are: how can I change all dates in the same time in the proper format with ought clicking on each date and in formula bar clicking enter (after the column is changed in date format)?
Thanks in advance!
Bookmarks