what is the "random" function in Excel in spanish?

G

Guest

I am currently working in an office in a spanish speaking country and need to
generate a random sample spreadsheet. However, the "rand" function doesn't
exist in spanish and I can't figure out what it is.. please help!!!
 
A

Ardus Petus

IN VBE immediatye window (Alt+F11, then Ctrl-G), enter:
activecell.formula="=RAND()"

Get back to Excel, you'll have the spanish equivalent in active cell.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Repeating a RAND() function under certain conditions 0
Calculating Mode for multiple arrays based on criteria in another 3
AmortInt function 3
I'm Having Problems with EOMONTH 8
Help on randomly selecting cells to SUM 2
randomise function in word 3
What does Excel's RAND function really do 0
generate a random number and use if function to generate new data 4

Top