COBOLforever
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
wow. wow. wow. I've been dancing all around that solution for years. So many thanks. really - huge for me. perfect.
Glad matthewspatrick got you sorted!
Glad to help :)
ASKER
124.50 vlookup = 124.5