Question about Excel (SS8SATAS5128400R)

2 Answers

Version Tracking in a workbook

I recelntly bought a training manual with EXCEL. In that training worksheet, if I
write =version , the version number will appear in the cell that I entered =version.

However, when I enter =version into my own seperate new worksheet, all I get is ?NAME. How do I enter a version number/tracker in a new workbook?

Posted by on

2 Answers

FORMULA OF EXCEL ALL

Posted on Jul 29, 2008

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 18 Answers

Hi blackhand18,

This might be different on your version of excel but try this

=INFO("release")

Posted on Jul 20, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

Have a used laptop excel asks for product key but i click cancel and have used the software but now it opens and i can't edit or do anything is there a way to fix it or is there a way to download another...


MS Excel is not afree program.
You will need to purchase a copy of MS Office which includes Excel.
For an alternative free program OPEN OFFICE is a full-featured officesuite that's compatible with Microsoft Office.
If you want Open Office you can download this free program.
Click on this link to download :-
http://www.openoffice.org/

Mar 03, 2011 | Excel (SS8SATAS5128400R)

1 Answer

Remove excel password


HI!
Just go to google.com and type the following into the search box.

Excel Password Unlocker free download

and find a free office password unlocker.

most password unlocker tools do not give you the password to unlock your workbook, they just go into the system workings and unlock the entire workbook for you.

save a copy of your locked up workbook. only try the breakers on a copy, just in case.

Sep 28, 2009 | Excel (SS8SATAS5128400R)

1 Answer

EXCEL


You will need to write a Macro that questions each position and turns it into a word depending on it's value ...

Something like :

DIM WordValue as String
DIM LenghtIndex as integer

FOR lenghtindex = 1 to Len(ExcelCellValue) DO

CASE StrCpy (Number, LenghtIndex , 1)
1 : WordValue = WordValue & "one"
2 : WordValue = WordValue & "two"
3 : WordValue = WordValue & "three"
4 : WordValue = WordValue & "four"
END CASE

END FOR

If you want it to realy say fourthy four when the value is 44 instead of have it say "four four" you need to question the position. If it's in second position starting from left it will be fourty , if it's in third place it will be fourhundred ... etc

Aug 22, 2008 | Network Storage Systems

1 Answer

HELP with macro config


Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table
table_to_check = the table you want to find the data from
column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.
range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here
B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)
G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)
etc

Jul 12, 2008 | Excel (SS8SATAS5128400R)

2 Answers

Attendance sheet in Excel


Hi KDina,

If you need me to work on this project for you please contact me at hdbas8@gmail.com

May 17, 2008 | Excel (SS8SATAS5128400R)

1 Answer

To turn hours and minutes into decimal


Let's say that the time is in cell C3.
Now in cell D3 type =C3*24
then format cell D3 as Number.

Hope this helps.

Apr 24, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Excel password removing


could you please supply us with the version of Excel you are using? it's under Help About Excel

Mar 04, 2008 | Excel (SS8SATAS5128400R)

3 Answers

Forget excel 2003 password so how break it pl help


You can recover your lost excel password with the use of excel password recovery software likehttp://www.stellarinfo.com/password-recovery/excel-password-recovery.php
First use trail version if you are satisfied with result then go with full version?

Feb 16, 2008 | Excel (SS8SATAS5128400R)

5 Answers

Excel


If you don't have MS Office, then you will have to purchase either the Excel component as a stand alone but you would be better off with the whole MSOffice as it contains your Word processor, Database, Excel, Powerpoint presentation software and in the 2003 version also Publisher.

It is not too badly priced anymore, but if you cant afford it then you may be able to borrow a copy whilst you are doing your course from a friend, but you will have to uninstall it afterwards.

Oct 26, 2007 | Excel (SS8SATAS5128400R)

Not finding what you are looking for?
Network Storage Systems Logo

Related Topics:

138 people viewed this question

Ask a Question

Usually answered in minutes!

Top Excel Network Storage Systems Experts

Geoff

Level 3 Expert

413 Answers

Brad Brown

Level 3 Expert

13542 Answers

Daily Mehdi
Daily Mehdi

Level 2 Expert

48 Answers

Are you an Excel Network Storage System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...