How to apply a tick in excel

[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.

[oldchippy]

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

[VBA Noob]

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

[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

Please Login or Register  to view this content.

VBA Noob

[ipbr21054]

picking a number only changes the cell in question,if i need to enter 1.00 6.00 9.00 etc all over the page did not want to do this each time.
Can something be changed so it will show as typed.
Thanks

[oldchippy]

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

[ipbr21054]

That works ok but when a new sheet is opened i need to do it every time.
Cant i changed the preferences etc so in the future i can just enter 1.00 and thats it,excel remembers to put in that cell 1.00 and not have to format anything.

[oldchippy]

The thing is, if you formatted all the cells to two decimal places, and needed to enter a date i.e. 21/10/2007, that would format to 39376.00 which is the underlying number for that date, so you would have to format that back to a date.

[VBA Noob]

How about turning on the macro recorder and store the macro in personal and assign a shortcut key (explained below)

Select some cells format as number. then next time select the cells and rum macro with the shortcut

Code would look like

Please Login or Register  to view this content.

http://www.bettersolutions.com/excel...C420921011.htm


http://www.bettersolutions.com/excel...C216621011.htm

VBA Noob