How to apply a tick in excel

Hi just joined and looking for a small piece of help if i could.
I am using Microsoft Office 2003 and i would like to know when in excel i type 1.00 "£1"it shows 1 please advise how i can change something so it will read 1.00
Also is it possible to insert a "tick" into a cell.

Thanks very much for your time in reading this.

Originally Posted by ipbr21054

Hi just joined and looking for a small piece of help if i could.
I am using Microsoft Office 2003 and i would like to know when in excel i type 1.00 "£1"it shows 1 please advise how i can change something so it will read 1.00
Also is it possible to insert a "tick" into a cell.

Thanks very much for your time in reading this.

Hi ipbr21054,

Welcome to the forum, click on the cell, right click > Format Cell > Number, then pick Number.

To put a tick in a cell, one way is to hold Alt+0252, (but use the number keypad on the right) your cell will have a ü in it, format this cell to Wingdings Font and it will change to a tick

Couple of other ways.

Format cell as Webdings and enter a lowercase a
Format cell as Wingdings 2 and enter a uppercase P
Format cell as Marlett and enter a lowercase a

VBA Noob

Or with a event macro. Right click the sheet name e.g sheet1. Select view code and paste in the below. The range is set as A1 to A100 but change as required.

Now as soon as you select a cell in that range it inserts a tick. to untick just reselect the cell

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Cells.Count > 1 Then Exit Sub
        If Not Intersect(Target, Range("A1:A100")) Is Nothing Then
            Target.Font.Name = "Marlett"
                If Target = vbNullString Then
                    Target = "a"
                Else
                    Target = vbNullString
                End If
        End If
End Sub

VBA Noob

Try this click in the blank cell, hold Ctrl+a, this selects the whole sheet, right click > Format Cell > Number, then pick Number