#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Try:
=--A1=--B1
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Trouble on Using List number style in Master Document | nattasiray | Word | 2 | 12-16-2011 08:01 PM |
Heading Numbering Trouble shooting | CanvasShoes | Word | 3 | 04-06-2011 05:10 PM |