Converting a date to sring using FORMAT() gives wrong format

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Converting a date to sring using FORMAT() gives wrong format

FAQ

Thread Tools

Display Modes

09-13-2023, 11:24 AM

BobBridges BobBridges is offline

Windows 7 64bit Converting a date to sring using FORMAT() gives wrong format

Office 2010 32bit

Expert

Join Date: May 2013

Location: USA

Posts: 700

Just a notion, but you say you're writing out the results in a text file. Any chance you mean it's CSV? A CSV doesn't know anything about formatting. If not, we might need more detail about how you know what format is being returned. I know, it sounds silly, but silly mistakes do exist out there.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail merge field mistakenly interpret text format as date format	alan6690	Mail Merge	0	09-02-2020 01:54 AM
Date is displayed in the wrong format	shawn.low@cox.net	Mail Merge	1	12-28-2019 02:17 AM
Converting letter format documents to A4 format	TJB	Word	1	06-01-2016 06:35 AM
converting mm.s format to mm:ss	derohanes	Excel	12	10-30-2012 08:34 AM
Converting from DOC files to PDF format	obenix	Word	2	04-29-2005 04:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:03 AM.