How do I concatenate a 'masked' numeric value in Excel

Posted on 2011-10-05
Last Modified: 2012-05-12

I have a number cell with a Custom mask of 000, so for example, in cell A3 the value 45 is displayed as 045.
I now want to use that value in a concatenated formula, for example, ="INV"&A3
so that it is displayed as INV045 and not as INV45 as it does currently.

What do I need to add to this formula to display as required ?
Question by:Tocogroup
    LVL 17

    Accepted Solution


    Open in new window

    Should do it
    LVL 2

    Expert Comment

    Hello Tocogroup

    Try using =IF(A1>99,"INV"&A1,"INV0"&A1)


    Author Closing Comment

    Thanks guys,
    The TEXT solution works fine.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now