View Single Post
 
Old 12-06-2016, 10:43 PM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
 
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