Excel - How do I repeat a character in a cell in Excel as / did in Lotus?

Asked By SoSoPr on 30-Mar-07 08:16 PM




Dave Peterson replied on 30-Mar-07 09:14 PM
Format|Cells|Alignment tab|Horizontal alignment dropdown|choose fill.




--

Dave Peterson
David McRitchie replied on 30-Mar-07 10:29 PM
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/excel.htm#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