Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
P3SAB$
 
Posts: n/a
Default How do I get keep the format (superscript) from a table?

I have a report that is using a vlookup to come up with a value. The
vlookup table has cells with superscripts. How do I keep the superscript
format when the lookup returns a value. Not all data in the table has a
superscript.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default How do I get keep the format (superscript) from a table?

Formulas return values--not formats.

Maybe a macro that would copy|paste would work???

P3SAB$ wrote:

I have a report that is using a vlookup to come up with a value. The
vlookup table has cells with superscripts. How do I keep the superscript
format when the lookup returns a value. Not all data in the table has a
superscript.


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I format a pivot table column - permanently? fnov Excel Discussion (Misc queries) 3 May 19th 23 07:44 PM
Pivot Table Row Field Format (OLAP Source) Adrian Morris Excel Discussion (Misc queries) 2 December 16th 05 10:37 AM
Pivot table formats text data with 2 decimals Don S Excel Discussion (Misc queries) 3 October 6th 05 12:45 AM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
Another Exciting Data Table Question!!!! xinekite Charts and Charting in Excel 1 May 29th 05 01:22 PM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"