| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Maintain Formatting with Formulas
I am writing a formula that references multiple cells as the possible source
cell depending on certain parameters being met. My question is whether anyone knows how to maintain the formatting in the display cell? My possible source cells all contain different number formats (i.e. -1234.0 and ##00.0E-+00). Is there a way to write this into the formula, or is there a formatting option that allows you to keep the source cell's format? Any help would be great! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save as web page (Maintain formulas) | Excel Discussion (Misc queries) | |||
| How do I import data from lotus123 & maintain formulas/worksheets | Excel Discussion (Misc queries) | |||
| how do I maintain my conditional formatting when filtering cells? | Excel Worksheet Functions | |||
| How can I sort and maintain formatting? | Excel Discussion (Misc queries) | |||
| formulas won't maintain during sort -help please! | Excel Worksheet Functions | |||
Threaded Mode
