Adding a leading space to a numeric column

[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

 

[Grth]

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

 

[Bernard Liengme]

=" "&A1
but you gave no details so this may be inappropriate
best wishes

 

[Earl Kiosterud]

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.