LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22
Default Format change when user select a Factor on drop down box

I have a drop down box with many Factors. when the user select one factor
below I like the data to show up as correct format on the out put .
How can i do it ?
Drop down box 1- Merchandise $
2- Gas $
3- Merchandise margin %
4- Gas margin %

on cell A4 I format as Currency.




--
thanks
 
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
Change of cell format if overwritten by User GrahamB Excel Worksheet Functions 1 February 23rd 07 09:21 PM
How can I allow a user to select more than 1 drop down item? stlblackbeltsmom Excel Worksheet Functions 2 December 18th 06 05:30 PM
Does a format in Excel change when another user opens the file? beachbum Excel Discussion (Misc queries) 1 September 5th 06 05:49 PM
Can a user select more than one entry in a drop down list? Brendan Excel Worksheet Functions 1 July 6th 06 04:40 AM
select drop down list 1 value will change the value in dr... Vincent Excel Worksheet Functions 1 February 3rd 05 11:52 AM


All times are GMT +1. The time now is 08:12 PM.

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

About Us

"It's about Microsoft Excel"