excel 2010 to format a date

		Microsoft Office Forums > Microsoft Excel > Excel
excel 2010 to format a date

FAQ

Thread Tools

Display Modes

03-28-2013, 02:33 AM

macropod

Windows 7 64bit excel 2010 to format a date

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,363

Hi Jassie,

Your second line is quite unclear. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.

FWIW, to coerce a number into a date/time string, you could use a formula like:
=TEXT(A1,"YYYY-MM-DD hh:mm:ss")

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create microsoft Excel 2007 and 2010 File in .xlsx format	ipacesetters	Excel	1	12-16-2019 05:13 PM
MS Query date format	remigio	Word	3	08-21-2012 10:54 PM
date format	gsrikanth	Excel	1	12-28-2011 05:06 AM
Mail merge will not format date field generated by Excel IF statement	borntorun75	Mail Merge	3	12-16-2011 06:28 AM
Excel 2010 Format cells to use as Gantt or Plan	Kizzie	Excel	0	12-13-2011 02:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 AM.