| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatig cells
Thanks for reading this post.
How can I CUSTOM format a cell to have the the text USD/TT/2008/ precede the number entered in the cell. eg. Number entered is 0001; required format is USD/TT/2008/0001 Is their any way I could further improve on this. For instance in cell Aa if USD is entered the format in cell B1 should be USD/TT/2008/0001 and if GBP is entered it should be GBP/TT/2008/0016 and so on (0001 and 0016 are variables entered manually). Regards Preman |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| Cells won't change font color or show hi-lighted cells in document | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
| Print Formatig | Excel Discussion (Misc queries) | |||
Threaded Mode
