• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Excel - incluce reformatted number in building a literal text string

Hi,

I have a dollar amount that is being retrived via Vlookup. It contains a decimal. The amount is not more than 9999.99. I need to insert it into a text string with the format of 000000 where the last two positions are the cents (probably obvious but want to be explicit here...). I cannot get it to work - tried creating new intermediate column and different formats for that etc.

Thanks much
0
COBOLforever
Asked:
COBOLforever
  • 2
  • 2
  • 2
1 Solution
 
COBOLforeverAuthor Commented:
Also - when I vlookup the amount comes over as:
124.50  vlookup = 124.5
0
 
redmondbCommented:
Hi, COBOLforever.

Is this the kind of thing you're looking for?

Regards,
Brian. No-to-String.xlsm
0
 
Patrick MatthewsCommented:
Just structure your VLOOKUP like this:

=TEXT(100*VLOOKUP(A2,LookupRange,2),"000000")
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
COBOLforeverAuthor Commented:
wow. wow. wow. I've been dancing all around that solution for years. So many thanks. really - huge for me. perfect.
0
 
redmondbCommented:
Glad matthewspatrick got you sorted!
0
 
Patrick MatthewsCommented:
Glad to help :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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