I SHALL BE THANKUL TO SOLE MY PROBLEM AS UNDER :

CONVERT FIGURE INTO WORD

CALCULATE WORKING DAYS

THANK U

I want to convert the figure / number in word

eg. 1,000 = ONE THOUSAND

Posted on Apr 16, 2009

Convert figure into world

& send employees attendence sheet & Pay role in excel base

Posted on Aug 22, 2008

Hi! plz how can i convert figure (dolars) to english word. e.g. 1,210,000.00 dolar to words.

thanks

Posted on Jul 19, 2010

Hi,
Check this site and download the figure to word converter:

http://www.a1vbcode.com/app-3664.asp

I haven't tested the code, please check the code and let me know whether

it is working or not....

Thanks

Posted on Aug 30, 2008

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

The WorkDay Function returns a number that's the serial date that is the indicated number of working days from a given date (the starting date). Working days EXCLUDE weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.

The Syntax is:

=WORKDAY(start_date,days,holidays)

where:

- start_date is in Date format (and can be a calculated value);

- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);

- holidays is an array of holidays you can specify if desired.

The Syntax is:

=WORKDAY(start_date,days,holidays)

where:

- start_date is in Date format (and can be a calculated value);

- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);

- holidays is an array of holidays you can specify if desired.

May 01, 2014 | Microsoft Excel for PC

contact Microsoft illegal software hurts everyone.

Jul 07, 2009 | Microsoft Office Professional 2007 Full...

not sure if this is what you are after entirely but should at least help you out some what

=DATEDIF(A3,C3,"m")/3

As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates

=DATEDIF(A3,C3,"m")/3

As you said you cant just divide by 3 but I have divided the formula by 3 to see how many 3 months will go into the output you could maybe have another formula to divide it by 2 to see if it will divide by 2 to see if you get a whole number or not, if you do then you can just return the first part before the dot ( using split function ) and if the value is less then 1 then obviously the 3 months has not passed between the 2 dates

May 09, 2009 | Microsoft Office Excel 2003 for PC

KGFVY-7733B-8WCK9-KTG64-BC7D8

SEND your ms office product key

you will sole this problem, to mail me my my site

SEND your ms office product key

you will sole this problem, to mail me my my site

May 01, 2009 | Microsoft Office Home and Student 2007 for...

BAHTTEXT(number)

The above function will convert a number to text. If you are referring to "figure" as a number than this should work for you.

You may want to try the TEXT(value,format_text) fucntion too but you'll need to supply a number format.

The above function will convert a number to text. If you are referring to "figure" as a number than this should work for you.

You may want to try the TEXT(value,format_text) fucntion too but you'll need to supply a number format.

Apr 22, 2009 | Microsoft Office Excel 2003 for PC

The easiest I can think of converting numbers into text in 2 colums is using a LOOKUP function in Excel. I have no knowledge of the range of numbers you are working with though so it may sound easier than it is...

Mar 25, 2009 | Apple Computers & Internet

use the below formula to get the date of the LWD (Monday thru Friday) of the month.

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Jan 30, 2009 | Microsoft Excel for PC

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

You need to calculate the totals for each category, by entering a formula such as: = C2 * 12.00 where C2 is the location of the hours and your hourly rate is $12.00. You can fill in the C2 part in each formula by clicking on the cell you want the total in, then typing the equal sign, then selecting the cell that you want to get the hours from, then enter the multiply operator (asterisk *) which is a Shift + 8 on your keyboard or the * over the 9 key on the numerical keypad. Repeat for each entry, using the correct cell and the correct amount (in this example it might be $18.00 for overtime hours). Then you just total all the formulas by using Autosum, which you invoke by using the Ʃ symbol, which will give you a sum of the cells you select. If this isn't clear enough, please let us know.

Hope this will FixYa!!!

Hope this will FixYa!!!

Mar 03, 2008 | Computers & Internet

the formulae for the surface area of round disc is

pi * r * r

where pi=3.14 and r =radious of disc= diametre/2

for this 1st u have 2 calculate the radious of the disc that is

180/2=90mm

then convert it to m by dividing 1000 ,so radious=90/1000=0.09 m

finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres

for 38 disc multiply 38 with the above area that is

0.025434 * 38=0.966492 sq metres

in excel 2007 u can do it more easily by going 2 formulas tab.

Under formla tab click on engineering formula and then convert

here u can convert from mm to m

after converting use the above formula i just told u.

pi * r * r

where pi=3.14 and r =radious of disc= diametre/2

for this 1st u have 2 calculate the radious of the disc that is

180/2=90mm

then convert it to m by dividing 1000 ,so radious=90/1000=0.09 m

finally calculate the area= 3.14 * 0.09 * 0.09=0.025434 sq metres

for 38 disc multiply 38 with the above area that is

0.025434 * 38=0.966492 sq metres

in excel 2007 u can do it more easily by going 2 formulas tab.

Under formla tab click on engineering formula and then convert

here u can convert from mm to m

after converting use the above formula i just told u.

Feb 27, 2008 | Computers & Internet

2,651 people viewed this question

Usually answered in minutes!

convert figure into words

i want convert figure in word in Microsoft Office Word 2003

what is your specific need?

×