Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion Standard

Excel 2007

what is the difference between numbers and currency?

RE: Excel 2007

Hiya Nicky

As for your the answer to this question there is a difference between the 2, and it will depend on why you are using currencies or just numbers

when you use just number formats then you can have positive and negative number or any type of number.

If you are dealing with other countries for example europe or the states then the numbers will need to have a currency associated with them so the only reason you need a specific symbol for that countries currency

I hope this makes things clearer

Mark East

Excel tip:

Change the Value of a Constant

When using a named constant in a worksheet, you may wish to change the value of that constant.

From the 'Insert' menu, select 'Name', then select 'Define'.

In the 'Define Name' dialog box, select the constant that you want to change.
Change the value in the 'Refers To' box.
Click OK.

Wherever that named constant has been used it will now use its new value.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.