Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting a cell with a formula
Hello,
In would like help with adding a dash to a series of numbers. I know I can format with special formatting using 0-00. However the result does return a hit when I search with the -00. Can you offer a formula that will add the dash and yield a result that can be searched. Thanks for the help (example below) Now Needs to be 38605.................386-05 118306...............1183-06 511602...............5116-02 553404...............5534-04 553703...............5537-03 597309...............5973-09 597704...............5977-04 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting if a cell contains a formula | Excel Worksheet Functions | |||
cell formatting with formula | Excel Worksheet Functions | |||
Formatting Cell that Contains If/Then Formula | Excel Discussion (Misc queries) | |||
cell formula or formatting | Excel Worksheet Functions | |||
Formatting a formula within a cell | Excel Discussion (Misc queries) |