ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Number Formats (https://www.excelbanter.com/excel-discussion-misc-queries/155885-number-formats.html)

michelle

Number Formats
 
2003 Excel - I have imported data into a file and want to create a lookup
formulae that will return a description when matching two numbers. The
numbers do not appear to be in the same format and therefore the lookup
formulae is not working. I have tried changing formats but nothing seems to
be working. Any help appreciated

michelle

Number Formats
 
No answer required, I have now found the answer from another forum - thanks

"Michelle" wrote:

2003 Excel - I have imported data into a file and want to create a lookup
formulae that will return a description when matching two numbers. The
numbers do not appear to be in the same format and therefore the lookup
formulae is not working. I have tried changing formats but nothing seems to
be working. Any help appreciated


Sandy Mann

Number Formats
 
"Michelle" wrote in message
...
No answer required, I have now found the answer from another forum


And it's a secret!

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk




All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com