| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I repeat a character in a cell in Excel as / did in Lotus?
I would have guessed something like asterisk protection
to fill empty space to the left, rather than repeating entire number. Format, Cells, Number (tab), Custom, //examples// $***55,000.00 _($**#,##0.00_);[Red]_($**(#,##0.00);_($* "-"??_);_(@_) ***$55,000.00 _(**$#,##0.00_);[Red]_(**$(#,##0.00);_(**$0.00_);_(@_) The first asterisk indicates that the next character is a fill character. You can have a leading or trailing fill see my http://www.mvps.org/dmcritchie/excel...m#numberformat --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Dave Peterson" wrote ... Format|Cells|Alignment tab|Horizontal alignment dropdown|choose fill. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| How do I remove a text character from an excel cell? | Excel Worksheet Functions | |||
| In an excel cell, I want my numbers indented less than 1 character | Excel Discussion (Misc queries) | |||
| in excel can one repeat the text from a the last used column cell. | Excel Discussion (Misc queries) | |||
| how can excel colour a cell when it has a specified character | Excel Discussion (Misc queries) | |||
Hybrid Mode
