Question about Compilers & Programming Tools

1 Answer

Excel Formula Require formula to convert $usd to £gbp on excel spreadsheet

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that has over 10 points.


    An expert whose answer got voted for 2 times.

  • Contributor
  • 32 Answers
Re: Excel Formula


Do you mean convert to the current currency rate? like you have 1$ in the cell and you want it to show .70 £

or do you mean to change the symbol? from $ to £

let me know,


Posted on Jan 11, 2008

Add Your Answer

0 characters

Uploading: 0%


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


3 Points

Related Questions:

1 Answer

Hello, am mr, just asking for registration key of wise engine email extractor,

hai this is alvina. I need to know how to use foxpro and how to evaluate the formulae's in excel sheet.

Mar 31, 2010 | Wise Solutions Wise For Windows Installer...

1 Answer

Formula reqd in MS Excel

hi-lite the whole spreadsheet
go to data and select auto filter
you will see that each column will have an arrow at the top for a pull down menu
click on the city you want and you will only see the hospitals in that city
be sure to save your changes and the autofilter will be saved

May 17, 2009 | Compilers & Programming Tools

2 Answers

Ms office formula guide

The Office Help file will explain each of the functions and their usage. Some formula's are very specific so some experience will get you going.

Mar 24, 2009 | Microsoft Visual Basic Professional...

1 Answer

Rating Teachers Behavior Inventory

You could assemble a simple Excel spreadsheet and then total, average, find the mean, standard deviation, trend or a host of other answers or information. You can lock the spreadsheet so no one can tamper with it or change the structure. That would be much easier than creating a special program unless there is a specific reason to do so.

Mar 21, 2009 | Microsoft Compilers & Programming Tools

1 Answer

Write into excel format

You can use ADO or SQL to open the excel file directly (provided it is constructed correctly, ie fields names) and write the data to it without Access.
That might be eaiser thatn converting it from Access to Excel, if that can even be done.

Feb 17, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Want to update the dates in excel spreadsheet

Try inserting seperate entry for furture day number and then reference that entry address for program math. You will have to either use same number of days to repeat (automatic) this math or accept that it would be a single shot type math. Depending on which version of excel you are using the alert can be a sound or color change. If 97 or older, there is no alert available. 2000 isn't much better.
Easier to set furture date in orginial date block right from the start. Unless you are running the excel program continuously in the background, program will only check date when running.

Good Luck,

Jan 16, 2008 | Compilers & Programming Tools

2 Answers


Excel is not able to be programed like that and still retain the data. Create 12 monthly spreadsheets and use them as they are needed.

Dec 08, 2007 | Compilers & Programming Tools

Not finding what you are looking for?
Compilers & Programming Tools Logo

Related Topics:

226 people viewed this question

Ask a Question

Usually answered in minutes!

Top Compilers & Programming Tools Experts

Robin Hill
Robin Hill

Level 3 Expert

1246 Answers


Level 3 Expert

18257 Answers


Level 3 Expert

733 Answers

Are you a Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides