dynamic formatting of cells
From: Joe Powers (jpowers_at_hanys.org)
Date: 08/05/04
- Next message: Bill L: "Lookup possibly?"
- Previous message: Chip Pearson: "Re: Excel Workbook automatically (by design) runs a macro"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 05 Aug 2004 12:28:14 -0700
Hi all,
I have a workbook that contains a data page and a report page. The
report page is generated by a combobox on the data page which basically
lets the user pick a financial indicator from a list. When the indicator
is selected, the report fills with the #'s for that indicator. However,
each indicator has a different # format, i.e. I have $, % and 2 decimal
# formats). I would like the report page to have the # format of the
indicator selected on the data work***. Is there a simple way to
accomplish this?
TIA
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
- Next message: Bill L: "Lookup possibly?"
- Previous message: Chip Pearson: "Re: Excel Workbook automatically (by design) runs a macro"
- Messages sorted by: [ date ] [ thread ]
