Adding a leading space to a numeric column

  • Thread starter Thread starter twillett
  • Start date Start date
T

twillett

Group:

How can I add a leading space to a column of numbers in excel?
Excel 2007

For example:

12345
54321
98761

I need a space peceding the numbers.

Thanks in advance.
Terry
 
Do really need a space added to the number or do you want to shift the
numbers a little to the right for legibility/esthetics .
To add a space
= " " & 12345

or
= " " & A1 if your data ("12345") is in cell A1.


if you want to nudge the numbers a bit to look better , use the "Increase
Indent" button in the toolbar.


GRth
 
Terry,

If Grth's suggestion to use indent isn't suitable for you, you can format the column (Format
Cells - Number - Custom) as

General (Note the space before General)
or
" "General

You'll also have to left-align the cells for this to matter.
 
Back
Top