98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » ' in cells
' in cells
Resolved · Low Priority · Version 2003
Wed 20 May 2009, 17:00Delegate Cedric said...
Cedric has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
' in cells
I might need to provide examples for this but it happens a lot that we receive spreadsheets that look fine, but when I click on a cell, a little ' appears before the value. When I click somewhere else the ' is not displayed anymore. This seems to affect Vlookups when comparing cells with ' and cells without...
Using 'delete', 'paste special' doesn't seem to remove that '.
Thu 21 May 2009, 11:10Trainer Amanda said...
RE: ' in cells
Hello Cedric
Thank you for your question and welcome to the forum.
The numbers you see with the ' in front of them would have been typed into the cells in that way on purpose.
What this does is that it ensures that the number is stored as text, rather than a number. This will affect VLOOKUPs, as noted in Excel Help on VLOOKUPs:
Remarks
When searching text values in the first column of table_array, ensure that the data in the first column of table_array does not have leading spaces, trailing spaces, inconsistent use of straight ( ' or " ) and curly (
Wed 27 May 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlinesExcel 2010 allows you to change the colour of grid lines instead of keeping them in boring black. |
