How do I get a line under my number that is just 1 char more?

M

megan

I would like to have an underline under my number that is just one character
more than the number. If I use the underline feature, it only underlines the
number and if I use the border feature, the whole cell is underlined.
 
R

Rick Rothstein

If your number is a real number, you can't do what you want. However, if you
don't mind your number being text, then format the cell it is in as Text,
add a space after the number and then underline the number plus the space
you added after it.
 
S

Sheeloo

Suppose you have a number 1234 in A1
Replace it with =1234&T(" ") or =Concatenate(1234," ") and underline

You can still use the values in the cell in numerical formulae.
 

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

Underline 3
How to determine char or number? 4
Remove a line 2
How do I extend underline across a whole cell w/o using the border 6
FIND 1 char in cell of any 3 char =True 5
Why is one cell showing numbers in blue and how do I change that? 7
Format for underlining a cell 5
Double Underline / Bottom Border 1

Top