Right formating with an ident

  • Thread starter Thread starter Yakimoto
  • Start date Start date
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
 
Format the cell with a custom format of (without quotes) "@ "
Just put as many spaces as you need.
 
Since you said the cell would contain a number, you would probably use:

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

as a custom number format.
 
Back
Top