Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-21-2012, 06:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Vlookup help for large amounts of stock data Windows 7 64bit Vlookup help for large amounts of stock data Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default


To make things easy extract the dates again using
Code:
=MID(F2,1,FIND("---",F2,1)-1))*1
All dates will be coerced to real dates
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 09-21-2012, 07:39 AM
jyfuller jyfuller is offline Vlookup help for large amounts of stock data Windows 7 64bit Vlookup help for large amounts of stock data Office 2007
Advanced Beginner
Vlookup help for large amounts of stock data
 
Join Date: Jun 2012
Posts: 32
jyfuller is on a distinguished road
Default Ok

Excellent. It works now. Just for my knowledge: Why did it not recognize them as dates with the original formula? How does multiplying by 1 convert the cell into a number that excel recognizes as a date?

Thanks
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup help for large amounts of stock data indent alternate lines by different amounts rufusfrog Word VBA 5 02-25-2012 03:36 AM
Charting Help - Stock Prices Ligerdub PowerPoint 0 01-03-2012 04:59 AM
Stock levels RobertH Excel 5 01-24-2011 01:02 PM
Vlookup help for large amounts of stock data chart from large data set mcfie Excel 1 09-19-2010 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:17 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft