Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-06-2016, 10:43 PM
Haha88 Haha88 is offline Number and Text Formula Trouble Shooting Windows 8 Number and Text Formula Trouble Shooting Office 2010 32bit
Advanced Beginner
Number and Text Formula Trouble Shooting
 
Join Date: Mar 2015
Posts: 79
Haha88 is on a distinguished road
Default Number and Text Formula Trouble Shooting

Hi,

This probably simple to most so hope someone can help me please.

The formula is =a1=b1, expect return =true as has the same value, but returns = False

i.e: =5000=5000=False.

I understand it may be text against a number issue, how can i resolve this using a formula & without having to change the data source.

Many thanks,

Haha
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Number and Text Formula Trouble Shooting Formula, Compare two cell's text and based on results output a number Offrddrver Excel 4 03-23-2016 11:32 PM
PPT Border (not background) while shooting video is black; want white Richardv2 PowerPoint 5 12-26-2014 06:29 PM
Trouble with List Number indentation and renumbering ravl13 Word 2 11-20-2012 07:44 AM
Number and Text Formula Trouble Shooting Trouble on Using List number style in Master Document nattasiray Word 2 12-16-2011 08:01 PM
Number and Text Formula Trouble Shooting Heading Numbering Trouble shooting CanvasShoes Word 3 04-06-2011 05:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:39 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