Results 1 to 6 of 6

Format Date

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

04-11-2014, 10:57 AM #2
Chris 53

View Profile

View Forum Posts
Forum Contributor

Join Date

01-30-2013

Location

Wales

MS-Off Ver

Excel 2013

Posts

231
Re: Format Date

Assuming date is in A1
=left(A1,8)

Click * below if this answer helped
Register To Reply

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

Converting from the 1904 date format to the 1900 date format without losing data

By Patty McJorst in forum Excel Formulas & Functions

Replies: 4
Last Post: 02-01-2020, 12:53 PM
Converting Twitter date format to standard Excel date format to use with WEEKDAY function

By dharmis in forum Excel - New Users/Basics

Replies: 5
Last Post: 02-08-2013, 11:06 AM
Conversion de date d'un format personnalisé à un format de date standard

By vince555 in forum Excel General

Replies: 1
Last Post: 06-15-2012, 02:03 PM
Need Formula/VBA Code to convert date in String Format to Normal Date format

By Karthik Sen in forum Excel Programming / VBA / Macros

Replies: 5
Last Post: 02-18-2012, 04:54 AM
Column Range with date Format MM/DD/YYYY independate of sys date Format

By gaursh in forum Excel Programming / VBA / Macros

Replies: 1
Last Post: 03-18-2011, 03:31 AM

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

All times are GMT -4. The time now is 09:45 AM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1