Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 229
Default randomise function in word

Is there any way to generate random number in word table just like rand()
excel function? thank for needful help
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,117
Default randomise function in word

you should probably try a microsoft.public.word group
susan

On May 25, 12:11 am, yshridhar
wrote:
Is there any way to generate random number in word table just like rand()
excel function? thank for needful help



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,365
Default randomise function in word

No, not in a table in Word. Word's tables are simply used to provide
organized presentation of information - not like Excel's tables at all.

You could do it in Word with a Macro. You could record a new macro while
choosing and inserting a number into the table, and then modify/edit the
macro created to use the RND() function in Visual Basic to place a number
into the table.

"yshridhar" wrote:

Is there any way to generate random number in word table just like rand()
excel function? thank for needful help

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default randomise function in word

There is an easy way. Rather than:
Table Insert
do
Insert Obkect Microsoft Excel Worksheet


You can put formulas like:
=RAND()
in the cells. When you click away from the embedded worksheet, it looks
just like a table!
--
Gary''s Student - gsnu200724


"yshridhar" wrote:

Is there any way to generate random number in word table just like rand()
excel function? thank for needful help

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
extract word function Dinesh Excel Worksheet Functions 14 November 23rd 06 05:49 AM
Can I randomise the order of a number of rows? plh Excel Worksheet Functions 6 November 12th 05 12:16 AM
how to copy the function argument box onto word Hannibal Excel Discussion (Misc queries) 1 April 13th 05 09:24 PM
how do i set an auto date function in excel or word? hpkcommish Excel Discussion (Misc queries) 2 February 22nd 05 10:23 AM
Is there a function to convert a number to word ? vazhga valamudan Excel Worksheet Functions 1 February 15th 05 12:05 PM


All times are GMT +1. The time now is 08:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"