How to lookup a value as displayed

		Microsoft Office Forums > Microsoft Excel > Excel
How to lookup a value as displayed

01-24-2023, 06:17 PM

wrdy

Windows XP How to lookup a value as displayed

Office 2007

Advanced Beginner

Join Date: Jan 2014

Posts: 31

OK, I've found the answer to my own question. I need to use the TEXT function, e.g. TEXT(123,"M00000").

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help with lookup / v lookup big failure	mda99das	Excel	4	11-04-2022 09:38 AM
contents not displayed	Rectorth	Word	0	02-10-2018 04:06 PM
LOOKUP - Complex lookup with 2 lookups in 1 cell	sglandon	Excel	6	05-05-2016 09:44 AM
image cannot currently be displayed	geddit	PowerPoint	1	06-18-2012 09:26 AM
'this image cannot currently be displayed'	eNGiNe	Word	0	02-02-2012 07:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:40 PM.