LOTUS 123 "\-" equivalent in EXCEL

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

In LOTUS 123 you can fill a cell with any character by
putting a bachslash in front of it. For example I use \-
and \= as my underline and double underline when totaling
a column of numbers. This allows me to include the
underline cell in the formula so if I need to add more
numbers below the bottom one my formula does not need to
be changed and the bottom cell does not need to be
formatted to add the underline. How can I do that in
EXCEL?
 
One way:

Enter your character, then choose Format/Cells/Alignment and choose
"Fill" from the "Horizontal" dropdown.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting a Lotus 123 file to Excel 2
Lotus 123 files 2
Lotus 123 Navigation 3
Fill without formatting 1
Is there an equivalent of Lotus 123's "Paste visible" command? 6
Exporting Lotus 123 into Excel Work Book? 1
Underlining in Excel 2003 1
Concantenate which keeps bold of some parts. 5

Back
Top