| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to format a worksheet based on values in another worksheet
I forgot to mention that the values in the "Format" column should probably
be entered as formulas of strings (i.e. ="00."), instead of just entering the value. Remember that Excel normally truncates leading zeroes from numbers, so trying to specify a number format that will display leading zeroes will be difficult or even impossible, without using a formula to force the value to a string. -- Regards, Bill Renaud |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| How do I copy cells from one worksheet to another based on values | Excel Worksheet Functions | |||
| Insert Rows Based on values in another worksheet | Excel Discussion (Misc queries) | |||
| Changing cell values based on a worksheet name | Excel Programming | |||
| Macro to translate values based upon data in another worksheet? | Excel Programming | |||
Hybrid Mode
