Formatting within function/equations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Trying to do some vlookup equations... they are working fine, but they only
bring over the value, not the formating. In the particular problem I'm
working on, the text value may or may not end with a superscripted number
(test^1). When the vlookup happens, the text appears the superscripted
number appears as regular text (test1). Anyway to build formating
capabilities within an equation?
 
Formulas return values--not formatting.

Maybe you could use a macro to copy|paste???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't copy and paste equations 0
Using Formatted Text with AutoCorrect in Excel 1
Format a field in an equation 4
Vlookups and formats 3
conditional format fails when copied 1
Vlookup and Trace Return Cell 2
Evaluate Equation in VBA 3
VLOOKUP function 1

Back
Top