Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default dynamic number format

I have a vlookup formula that will return different data based on a user
input. The data will either be a percentage or an integer. How can I
conditionally format the cell so that the number is formatted properly, or
that the vlookup returns the value and formats?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default dynamic number format

You can't use conditional formatting to change number format.

However, if all your percentages are non-zero and less than 1, you can
use Custom Format:

Format/Cells/Number/Custom...

[<=0]0;[<1]0.00%;0


In article ,
whitepa05 wrote:

I have a vlookup formula that will return different data based on a user
input. The data will either be a percentage or an integer. How can I
conditionally format the cell so that the number is formatted properly, or
that the vlookup returns the value and formats?

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
NUMBER OF ROWS IN A DYNAMIC RANGE Larry Excel Worksheet Functions 0 July 14th 06 09:19 PM
Number rows in a dynamic range fishmen Excel Worksheet Functions 3 May 5th 06 07:26 PM
Large number of dynamic charts kh Charts and Charting in Excel 3 March 1st 06 06:27 PM
I would like to format a dynamic chart title fayiama Charts and Charting in Excel 1 February 15th 06 03:12 PM
Dynamic number of ROWS Gerrym Excel Worksheet Functions 2 November 16th 04 05:03 PM


All times are GMT +1. The time now is 06:20 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"