Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 02-25-2013, 07:48 AM
OTPM OTPM is offline Formula Help Request Windows 7 32bit Formula Help Request Office 2010 32bit
Expert
Formula Help Request
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Paul
I still need your help .
If I type the data for the formula to work on the formula works fine. However if I copy the data from a "Text" file into Excel the formula does not work.
The data is pasted with a cell format as "General".
I have tried marking the column as "Text" prior to pasting the data but it still does not work.
I am getting #VALUE error which I know is conflicting data types but the data is in one cell!
Any help would be appreciated.
Thanks
Tony
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Help Request Formula help request JAMS Excel 2 04-06-2012 10:14 PM
Meeting Request Time Wrong aimav Outlook 0 03-26-2012 08:14 AM
Outlook Calendar request steve42399 Outlook 2 04-12-2011 09:35 AM
Meeting Request - Another Organizer coolpeter86 Outlook 0 12-12-2010 11:58 PM
Macro request: open on event infotech Outlook 0 12-08-2010 06:40 PM

Other Forums: Access Forums

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


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