LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 12
Default Formatting cells to show two dates in one cell

I have a column in my spreadsheet that is for the date that I recieve info
from clients. When I recieve this info on more than one date, I've been
putting a comma between the two dates.

I have a word document that I use merge to pull this information (along with
other info), but when I pull the data from this particular column, it changes
the dates to something like 12:00AM. I've tried changing the formatting of
this column to text and also to general, but it still will not give me just
the two dates.

I don't want to create another column for the second date, because the
spreadsheets is already a bit unwieldy.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format cells to show dates as the day of the week LO in Sweden Excel Discussion (Misc queries) 3 May 6th 08 04:45 PM
conditional formatting or formulae to show elapsed dates Jo Excel Worksheet Functions 3 May 26th 07 11:14 PM
How to format cells to show dates as the week-ending date of that dereksmom Excel Worksheet Functions 1 July 12th 06 04:40 PM
show nearst of two dates in new cell on excel matt clarke New Users to Excel 4 June 12th 06 11:31 PM
Formatting to show/not show "DUE" and "RECEIVED" in cell kevhatch New Users to Excel 5 October 9th 05 09:10 PM


All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"