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

Resolved · Low Priority · Version 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:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips