Ask Experts Questions for FREE Help !
Ask
    omarbull's Avatar
    omarbull Posts: 2, Reputation: 1
    New Member
     
    #1

    Oct 17, 2013, 11:12 AM
    (In Excel) I want that any digit I type should come with this *
    In Excel
    I want that any digit I type should come with a star like this * just like a percentage comes with this %
    Kevin-Radstock's Avatar
    Kevin-Radstock Posts: 8, Reputation: 3
    New Member
     
    #2

    Oct 22, 2013, 10:24 AM
    Hi

    Try formatting the cells, as " General"*" " with out the double quotes.
    GrantHillsSA's Avatar
    GrantHillsSA Posts: 405, Reputation: 9
    Full Member
     
    #3

    Nov 1, 2013, 03:08 AM
    Right click on the cells that you want to edit.
    Select Format Cells
    Under the General Tab, select custom on left bottom.
    "*"###### (Will look like this: *123456789)
    ######"*" (Will look like this: 123456789*)


    Hope this helps
    Grant - South Africa

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

I want that any digit I type should come with this * [ 1 Answers ]

I want that any digit I type should come with this *

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

by increasing indent in excel with seventh digit shows integer [ 1 Answers ]

In excel if I increase the indent more than 7 decimal digits showing the value: 55156180.4400003000000 but with increasing the indent to only 6 digits shows:55156180.440000 What could be the reason and how to resolve this issue. Request any suggestions.

My home has a four digit number, none of the digit is repeated, one day a mischievous [ 0 Answers ]

My home has a four digit number, none of the digit is repeated, one day a mischievous person turns the sign upside down. I find out that new number is 720 less than the old one. What was the orginial number?

20 digit problem in excel [ 1 Answers ]

I can not write 20 digit number in a cell of excel 2007.please guide


View more questions Search