Stars instead of numbers

J

John

Hello

Can anyone help me with the following: I need to display stars (*) in the
cell instead of numbers, meaning that when I enter the number 5 in a cell I
want to show 5 stars (*****) instead of the number 5.

Thanks
 
J

Joerg

Maybe a custom cell format: "***";"***";"***"
This will show any number as three stars, but text will be shown normally.

Cheers,

Joerg
 
J

Joerg

Here is more sophisticated version: **;**;**
This time no quotes necessary. The cell will be filled with stars up to cell
width.

Joerg
 
N

Niek Otten

It is easy to do that in another cell:

=REPT("*",A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello
|
| Can anyone help me with the following: I need to display stars (*) in the
| cell instead of numbers, meaning that when I enter the number 5 in a cell I
| want to show 5 stars (*****) instead of the number 5.
|
| Thanks
|
 
M

MartinW

Hi John,

Another option.
Use Tools>AutoCorrect>Replace text as you type and set

Replace: 5\
With: *****
Replace: 6\
With: ******
Etc Etc

Just use some sort of keystroke that you are never likely
to use in any situation. Other options are things like 5[ or
!5 or 5][ or whatever.

HTH
Martin
 
J

Joerg

Martin, this would *replace* the original input. I understand that the OP
just wants to *display* cell values as stars.

Joerg
 
M

MartinW

Hi Joerg,

I guess that the OPs post is a little ambiguous in the first line he says
display but in the second line...

<meaning that when I enter the number 5 in a cell I
want to show 5 stars (*****) instead of the number 5.>

Sounds like replace to me.

Regards
Martin
 
Top