Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble merging after formatting
I reformatted a date range (I had trouble doing this at first- the
date did not appear to reformat. I took someone's advice and replaced all the spaces with spaces as described only slightly less confusingly on this web page: http://en.allexperts.com/q/Excel-1059/Date-Format.htm and after that the date appeared correctly.) Now, however, I'm trying to do a merge into another program, but the date appears in a different format altogether. Originally: 8 June 2007 After Reformatting: June 8 2007 After Merge: 06/08/07 Any thoughts? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trouble merging after formatting
Try a helper column =TEXT(A1,"mmmm d yyyy")
-- David Biddulph wrote in message oups.com... I reformatted a date range (I had trouble doing this at first- the date did not appear to reformat. I took someone's advice and replaced all the spaces with spaces as described only slightly less confusingly on this web page: http://en.allexperts.com/q/Excel-1059/Date-Format.htm and after that the date appeared correctly.) Now, however, I'm trying to do a merge into another program, but the date appears in a different format altogether. Originally: 8 June 2007 After Reformatting: June 8 2007 After Merge: 06/08/07 Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trouble formatting page breaks | Excel Discussion (Misc queries) | |||
Trouble formatting date | Excel Worksheet Functions | |||
Trouble formatting Date data | Charts and Charting in Excel | |||
Trouble formatting | Excel Worksheet Functions | |||
Formatting for merging into Word | Excel Discussion (Misc queries) |