Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   (In Excel) I want that any digit I type should come with this * (https://www.askmehelpdesk.com/showthread.php?t=771637)

  • Oct 17, 2013, 11:12 AM
    omarbull
    (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 %
  • Oct 22, 2013, 10:24 AM
    Kevin-Radstock
    Hi

    Try formatting the cells, as " General"*" " with out the double quotes.
  • Nov 1, 2013, 03:08 AM
    GrantHillsSA
    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

  • All times are GMT -7. The time now is 04:59 PM.