| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a line under my number that is just 1 char more?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a line under my number that is just 1 char more?
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. -- Rick (MVP - Excel) "megan" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a line under my number that is just 1 char more?
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. "megan" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - mixed type (line, column, stacked column) in one char | Charts and Charting in Excel | |||
| FIND 1 char in cell of any 3 char =True | Excel Discussion (Misc queries) | |||
| Help!!! Extracting a number to line up with a different number | Excel Discussion (Misc queries) | |||
| 8500 cells with phone number(7 char.), wishing to add area code (10 char.) | Excel Discussion (Misc queries) | |||
| LIMIT NUMBER OF CHAR IN A COMBINE CELL | Excel Discussion (Misc queries) | |||
Linear Mode
