excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007

Excel 2007

resolvedResolved · Low Priority · Version Standard

Excel 2007

What is the difference between numbers and currency?

RE: Excel 2007

Dear Nicky

Thank you for attending Excel and Access Courses. I hope you enjoyed them.

The difference between Currency and Number is that a currency will display that it is a monitory value. When you have a currency with two decimal places e.g.


 

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips


Server loaded in 0.08 secs.