Right formating with an ident

Y

Yakimoto

How can I format a number value to the right, but with an identation? I can
see that there is an ident only for left formating in the format cell.

Merry Christmas
Yakimoto
 
R

Rob van Gelder

Format the cell with a custom format of (without quotes) "@ "
Just put as many spaces as you need.
 
T

Tom Ogilvy

Since you said the cell would contain a number, you would probably use:

#,##0____ ;-#,##0___)

as a custom number format.
 
Top