Question about Microsoft Excel for PC

2 Answers

Copy-paste Unable to download fraction values(7/4,100/30 etc)from documents on net to MS Excel.Copy-Paste converts into date format even when the excel sheet is ready to accept numbers. Thanks for help. azmanz@aol.com

Posted by on

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 45 Answers

Change cell format (ctrl-1) to fraction instead of date

Posted on Nov 17, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 120 Answers

It should be

=7/4  or =100/30
and excel will give you a numeric result.

Posted on Nov 12, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

I want to copy an Excel chart as a Image onto a PowerPoint Slide (Office 2007). What is the sequence of APIs to apply?


Copy worksheet data to a PowerPoint presentation
  1. In Excel, select the worksheet data that you want to copy to a PowerPoint presentation.
  2. On the Home tab, in the Clipboard group, click Copy za006044679.gif.

za010165428.gif

Keyboard shortcut You can also press CTRL+C.

  1. Click in the PowerPoint presentation where you want to paste the copied worksheet data.
  2. On the Home tab, in the Clipboard group, click Paste.

Keyboard shortcut You can also press CTRL+V.

  1. Click Paste Options za006043532.gif next to the data, and then do one of the following:
    • To use the original format of the copied data, click Keep Source Formatting.
    • To use the document theme that is applied to the PowerPoint presentation, click Use Destination Theme.
    • To paste table data that you copied as text, click Keep Text Only.

Notes

  • If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button za010077102.gif, and then click PowerPoint Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box.
  • If you paste the data into a PowerPoint table, the Paste Options button is not displayed.
Tips
  • To paste the data in another format (such as a worksheet object, HTML format, bitmap, picture, or to text format) or to paste a link to the source data in Excel, on the Home tab, in the Clipboard group, click the arrow on the Paste button, and then click Paste Special. In the As list, click the format that you want to use.
    • If you want to edit the entire worksheet later, click Microsoft Office Excel Worksheet Object. Clicking Microsoft Office Excel Worksheet Object provides access to the entire worksheet in the presentation, including data that you may want to keep private. To automatically update the table in the presentation when changes are made to the source data in Excel, click Paste link. Both of these options also preserve the Excel formatting, even when the formatting features that are used are not supported in PowerPoint. If you saved the source workbook before you copied the data, you can also click Attach Hyperlink to insert a hyperlink in your presentation that directs you to the source data in Excel.
    • To paste the content as an Object Linking and Embedding (OLE) (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) PowerPoint application icon (rather than pasting the actual content), click Microsoft Office Excel Worksheet Object, and then select the Display as icon check box. You can click the icon to open the application and then view the content.
    • If you want to use HTML to copy the data to PowerPoint into a PowerPoint table, click HTML format.
    • To paste a static picture, click Device Independent Bitmap or Bitmap, or to paste a picture that can be ungrouped, click Picture (Enhanced Metafile) or Picture (Windows Metafile).
    • To paste the data as formatted or unformatted text, click Formatted Text (RTF) or Unformatted Text.
  • To paste the data as a hyperlink that directs you to the source data in Excel, click the arrow on the Paste button, and then click Paste As Hyperlink. If the workbook that contains the source data has not been saved yet, this option is unavailable.
  • If you want the range of data that you paste as a Microsoft Excel Worksheet Object into a PowerPoint presentation to expand when the corresponding data expands on the Excel worksheet, you can define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the range of data in Excel before you copy the data. You can then paste a link to the named range by using the Paste Special command. On the Home tab, in the Clipboard group, click the arrow on the Paste button, click Paste Special, and then click Paste link. This works only when you copy data that is not in table format in Excel.

Mar 09, 2011 | Individual Software Professor Teaches Word...

2 Answers

How to insert the rupee symbal in excel


Let me add with a brief details on how to download, how to install and how to type Indian Rupee Symbol:
Click here to download INR Rupee font, download this, extract the font file (once you open the zip file, you'll see a file name "Rupee"), copy it and paste it in the Fonts folder of the Control Panel of your computer.
Open a word processing program like Ms-word (in your case, Excel) and select the font as "Rupee" from the drop down lists, now press
543c056.jpg


on the keyboard.
You'll see the Rupee symbol :
a8b9730.jpg

Good luck.
Thanks for using FixYa.

Jul 21, 2010 | Microsoft Excel for PC

1 Answer

In ms word what is the use of paste special


Paste special allows you paste the text copied to the clipboard with the following options:

1. You can paste the text along with the format.
2. you can paste only the values and the formatting will be the format of the document you are pasting on.
3. You can simply paste it as text (i.e. without any formatting).

Jun 29, 2010 | Computers & Internet

2 Answers

Im trying to copy text from ms word and burn it to dvd with no luck i have downloaded various softwarw programmes but still no good .please help


Once you copy (text, picture etc) from any file, You need to paste it somewhere before you can burn it. Once you copy something, computer holds it on something called a clipboard till you paste it to another document. This new document can be a notepad or another word file. So, once the copy is done, open note pad or an MS office new file and paste it on to that. Save this new file with any name (abc.txt or abc.doc for example). Now you can burn it to a CD or DVD. To burn, open the CD burning software. Start new data project, drag abc.doc or abc.txt file to the window at the bottom. click burn.

Mar 21, 2010 | Computers & Internet

1 Answer

Excel 2003 cell is highlighted, font color is selected, but the color on the screen remains black. When printing the color prints out correctly while showing black on the screen


to remove all formats....
i.e.
open another workbook....
copy all data from the present sheet to the new work book....
present workbook
select data/edit/copy

new work book
select cell edit/paste special/values

now do the formating/color/font/size etc in the new workbook and check if they work here

Dec 14, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

I had data on sheet one and for same the text format on another i want to copy data in the sheet having text format for particular cell reference which is there on first sheet


Try using "Paste Special". Select the data you want to copy. Position your cursor on the new sheet. Select Edit / Paste Special. Try the "Values and number formats". If that doesn't copy all the formatting you want, on the second time select "Formats". I often do this as a two step process: do a normal cut and paste, then go back and do a "Paste special" selecting "Formats" to get the formatting correct.

Jun 26, 2009 | Microsoft Excel for PC

1 Answer

MS Excel-Values in the formula in place of cell reference


Copy the cell(s) and then right click on the cell(s). Choose Paste Special and then choose Value. That will convert it.

Jun 22, 2009 | Microsoft Excel for PC

1 Answer

Copy and paste between different workbooks


There should be 2 paste options when you right click in the new workbook - 'paste' and 'paste special'

choose 'paste special' and make sure that 'All' is selected not 'values'

Apr 24, 2009 | Computers & Internet

1 Answer

How to copy 395.6 and paste only 396 and copy 395.4 and paste 395


two options - 1st format the cells where you will paste (e.g. highlight one column - "the paste to column") by right clicking and choosing format cells, then number and set number of decimal places to 0 - then when pasting instead of usual paste (right-click>>paste or Cmd-V) choose Paste Special (right-click>>Paste Special) then choose Values so you don't override the format with the paste

option two - similar but just wait until you've pasted and format the pasted cells as Number>>0 decimal places.

Cheers,

Mar 26, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Hi


just copy and paste the entire thing of document and paste it to word blank document. bye

Sep 29, 2007 | Konica Minolta Dimage Scan Dual IV Film...

Not finding what you are looking for?
Microsoft Excel for PC Logo

111 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...