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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

How do you copy and paste one excel spreadsheet to another making sure the headers are lined up correctly.


right-click the sheet you want to copy, select "copy to", then either select the position within the current document, select annother document (needs to be open in the same excel instance) or select "new document". check the box "copy" to copy, leave unchecked to move.

Jan 01, 2016 | Microsoft Excel Business & Productivity...

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

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

Change the format of dates to simple numbers


Highlight the column you'd like format as a number and copy it. Choose another column and hit Paste Special and choose Value. The date is then represented as a number.

Aug 03, 2009 | Microsoft Windows XP Professional SP3 Full...

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

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

How to convert the pdf( telephone directerey page) to ms excel ?


Highlight and copy the text in the telephone directory PDF, paste it into excel and use the excel text to columns tool to justify the mess of text into the appropriate columns.
id say the delimited by spaces option would be the go with this one, though PDFS often have issues when trying this method.
You may need to pre clean the pasted data before putting it into excel with notepad using find and relace to remove double spaces and wierd charcaters.

Feb 17, 2009 | Microsoft Business & Productivity Software

1 Answer

Editing a document that has no security on it


This is an interesting problem. Since you've already tried copy/paste to a new document, I'll assume you don't care about the file so much as the text in it.

First, make a copy of the file and let's experiment with that.

You said you cannot copy the text, but I'm not sure if that is because you cannot "select" the entire text of the document or because the copy function is simply not working on that file. If you're able to open the document at all, try using keyboard commands to perform the copy/paste. Open the doc and leave the cursor at the beginning of the text. Then attempt to select all the text by pressing Ctrl-A. If that works, then press Ctrl-C. Leave the document open and press Ctrl-N to open a new doc page. Then press Ctrl-V and see if the text pastes in. One important thing to know would be if the text pastes but exhibits the same 'symptom'. If so, attempt an EDIT, PASTE SPECIAL and try pasting "unformatted text". Unfortunately, that method will also remove your formatting.

Here's another approach that may allow you to retain most MS Word formatting items. Click START, RUN and type "wordpad" .. Then hit ENTER. This launches MS Wordpad which should be able to open most .doc files. Use the FILE, OPEN menu items to locate and attempt to open the document in question. If from here you are able to select all the text (Ctrl-A) and copy it (Ctrl-C) and paste it (Ctrl-V) into a new doc file, then we will move on to another possible option.

Another approach would be to download one of the many different .doc repair utilities that exist. There are a number of free ones as well.. repairmyword.com advertises a number of free utilities you may have luck with.

Hopefully one of these will help fix the matter... if not, let us know!

Good luck!

Aug 26, 2008 | Microsoft Word 2000 for PC

2 Answers

Excel


Can you not just copy and paste your table into a Word document? Or insert a table into your Word document. And the auto save function is dependant on the version of Word you are using.

Sep 27, 2007 | Microsoft Office Standard for PC

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 Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...