Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel advanced - How do I change the currency of cell?

excel advanced - How do I change the currency of cell?

ResolvedVersion Standard

Tue 7 Nov 2006, 11:16 Delegate Jacob said...

Jacob has attended:
Dreamweaver MX Intermediate course
Outlook Introduction course
Access Advanced course
Excel Introduction course
Excel Advanced course
Access Advanced course
PowerPoint Introduction course
Dreamweaver MX Intermediate course
Access Introduction course
Project Advanced course
Excel Introduction course
Excel Advanced course
Frontpage Intermediate course
Access Advanced course
PowerPoint Intermediate Advanced course
Access Introduction course
Dreamweaver 8 Intermediate course
Word Introduction course
PowerPoint Introduction course
Access Advanced course
Excel Introduction course
Access Advanced course
Access Advanced course
Access Advanced course
Negotiating Skills course
Emotional Intelligence at Work course
Managing Change course
Taking Minutes course
Time Management course
Assertiveness at Work (2 days) course
Problem Solving / Decision Making course

How do I change the currency of cell?

Whenever I enter a value it goes to $ instead of

Tue 7 Nov 2006, 12:14 Trainer Amanda said...

RE: How do I change the currency of cell?

Select the cell, go to Format - Cells - Number and choose Currency option from the list of Categories. Change the currency symbol then click OK.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips

excel advanced - How do I change the currency of cell?

How do I change the currency of cell?

RE: How do I change the currency of cell?

Excel articles

Excel tip:

Hiding a worksheet in Excel