Microsoft Office Forums - View Single Post - How to lookup a value as displayed

Thread: How to lookup a value as displayed

View Single Post

Old

01-24-2023, 06:17 PM

wrdy

wrdy is offline

wrdy uses Windows XP

Windows XP wrdy uses Office 2007

wrdy uses Office 2007

Office 2007

Novice

The original poster

Join Date: Jan 2014

Posts: 28

wrdy is on a distinguished road

Default

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

Reply With Quote