Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

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

Hi,

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 ?
Thanks
Toco
0
Tocogroup
Asked:
Tocogroup
1 Solution
 
andrewssd3Commented:
="INV"&TEXT(A3,"000")

Open in new window

Should do it
0
 
LlanoVCommented:
Hello Tocogroup

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

 mask-example.xlsx
0
 
TocogroupAuthor Commented:
Thanks guys,
The TEXT solution works fine.
Regards
Toco
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now