| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting dates after importing data
Hope someone can help...
I have imported a large amount of data from a database application into a new spreadsheet. There is a column that includes dates of birth in the format ,say, 28.07.1965 How can I format the cells in that column so that they read in the format 28/7/1965. I have tried formatting the cells and trying different variations but they dont seem to have any effect on the existing data. I need to sort the data and the current formatting is not suitable. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting dates after importing data
With your data in a1, enter in B1:
=DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)) and sformat B1 to suit. -- Gary''s Student - gsnu200777 "Mick B" wrote: Hope someone can help... I have imported a large amount of data from a database application into a new spreadsheet. There is a column that includes dates of birth in the format ,say, 28.07.1965 How can I format the cells in that column so that they read in the format 28/7/1965. I have tried formatting the cells and trying different variations but they dont seem to have any effect on the existing data. I need to sort the data and the current formatting is not suitable. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting dates after importing data
Hi,
Select your column of dates then data|Text to columns Fixed width Next Next Select Date DMY Finish Mike "Mick B" wrote: Hope someone can help... I have imported a large amount of data from a database application into a new spreadsheet. There is a column that includes dates of birth in the format ,say, 28.07.1965 How can I format the cells in that column so that they read in the format 28/7/1965. I have tried formatting the cells and trying different variations but they dont seem to have any effect on the existing data. I need to sort the data and the current formatting is not suitable. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting dates after importing data
Great.
Thanks for your reply, what a time saver- cheers! "Mike H" wrote: Hi, Select your column of dates then data|Text to columns Fixed width Next Next Select Date DMY Finish Mike "Mick B" wrote: Hope someone can help... I have imported a large amount of data from a database application into a new spreadsheet. There is a column that includes dates of birth in the format ,say, 28.07.1965 How can I format the cells in that column so that they read in the format 28/7/1965. I have tried formatting the cells and trying different variations but they dont seem to have any effect on the existing data. I need to sort the data and the current formatting is not suitable. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting dates after importing data
DataText to ColumnsNextNextColumn Data FormatDateDMY
Format to Custom d/m/yyyy Gord Dibben MS Excel MVP On Mon, 7 Apr 2008 05:45:00 -0700, Mick B wrote: Great. Thanks for your reply, what a time saver- cheers! "Mike H" wrote: Hi, Select your column of dates then data|Text to columns Fixed width Next Next Select Date DMY Finish Mike "Mick B" wrote: Hope someone can help... I have imported a large amount of data from a database application into a new spreadsheet. There is a column that includes dates of birth in the format ,say, 28.07.1965 How can I format the cells in that column so that they read in the format 28/7/1965. I have tried formatting the cells and trying different variations but they dont seem to have any effect on the existing data. I need to sort the data and the current formatting is not suitable. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to turn off the automated dates in excel (when importing data) | Excel Discussion (Misc queries) | |||
| Formatting datetime problems importing data from mysql db | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Dates) Repost with additional data | Excel Discussion (Misc queries) | |||
| Importing data, and need formatting advice | Excel Worksheet Functions | |||
| Cell formatting when importing data | Excel Discussion (Misc queries) | |||
Linear Mode
