Question about Microsoft Excel for PC

1 Answer

CAN'T TYPE NUMBERS IN A CELL

THE CELL THAT HAS BEEN FORMATED WILL NOT LET ME NOW TYPE A TIME IN THE CELL IT GOES BACK TO 0:00, IT WONT KEEP THE TIME AS 12:30

Posted by on

  • Anonymous Feb 04, 2009

    No that didn't work, when the cell is formatted for time it won't keep the : signs for time in the cell and still goes back to o:oo if I type in a time exp: 10:35, then move from that cell and it still says 0:00.
    HELP!!!

×

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Microsoft Master
  • 2,976 Answers

Left click on the cell, right click on the cell, select remove formatting.

Posted on Feb 04, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

What is formula to find percentage of females in my workplace?


      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Business & Productivity Software

10 Answers

In Excel adding positive and negative numbers


Yes,


  1. Select the column. (click on top of the column it will select)
  2. Right Click and select Format Cells.
  3. Select Currency in Category then press OK
b6298df.gif Now just type your Numbers i.e. 571 for $571 and -650 for -$650 and sum using the normal way.

That is Select the Cells which you want to SUM and Press Alt+=

This will bring the total just below the selected cells.

Thanks
Iqbal

Apr 02, 2008 | Business & Productivity Software

1 Answer

Display numbers in a cell to 7 digits


Right click on the cell that you need to display as a 7 digit number and then choose FORMAT CELL the choose CUSTOM in the NUMBER tab and type seven zeros into the TYPE field, you will see in the preview that the display is formatted as you have requested and the added bonus is that the field still retains is numeric characteristics and can be easily used for calculations etc.

May 01, 2013 | Microsoft Excel 2010

1 Answer

How to display numbers in a cell to 7 digits


Right click on the cell that you need to display as a 7 digit number and then choose FORMAT CELL the choose CUSTOM in the NUMBER tab and type seven zeros into the TYPE field, you will see in the preview that the display is formatted as you have requested and the added bonus is that the field still retains is numeric characteristics and can be easily used for calculations etc.

May 01, 2013 | Microsoft Excel 2010

1 Answer

I am trying to type numbers with more than 3 digits and the program changes them to 3 digits, for example: typing 30000 , appears 300 in the cell. help!


  1. Right click on the the letter at the top of the column you are entering the larger numbers in and choose "format cells" from the drop down menu.
  2. Then click on "number" and this is where you can set the number of decimal places or other adjustments.
Thanks,
Robert

Feb 25, 2011 | Microsoft EXCEL 2004 for Mac

1 Answer

Unable to type in microsoft excel spreadsheet


Couple of possibilities:

The active window is selected.

Some cells might be formatted for numbers only. Check cell format.

Your font is white and you can't see your typing.

Oct 03, 2010 | Microsoft Office Excel 2007 Full Version...

1 Answer

I need to get "0.00" rather than "FALSE"


The quick way is to right click on the cell, and select format cells. Then click on the numbers tab, under category select Custom, in the Type box, put 0.00.
This will put the format to 0.00 when there is not other number in the cell,otherwise it will jsut keep any current number to 2 decimal palces.

Apr 04, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Excel formula.....


Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.

Put 65 in cell a1.
360 in b1
In C1, put the formula =a1/b1 that's your book thickness
In D1, put .02 for the cover
In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Jul 14, 2008 | Business & Productivity Software

1 Answer

Land measuring


Just follow the steps....
  1. Type "Enter Land in Gundas" in A1
  2. Type "Equivalent Land in Acres" A2
  3. Type "=B1/40"
  4. Now type the number of gundas in B1 example 100
  5. you will automatically get 2.5 in B2
Now you need only two decimals tighy?
  1. Select B2 Cell
  2. Right Click and goto Format Cell
  3. Goto Number
  4. Under Number select Number Catogory
  5. and then select 2 decimals
Thats all

Jan 31, 2008 | Business & Productivity Software

1 Answer

How to change the date format?


Select the cell or column or range containing the date(s). Click Format -> Cells On the Number tab, click Date This will give you the various formats available. The default date format is determined by the settings in the control panel. Windos XP: Control Panerl -> Date, Time, Language and Regional Options -> Change the format of numbers, dates, and times -> Customize This dialog box has tabs for Numbers, Currency, Time, and Date. There you can select the default formats for how you want things to appear. Hope this helps.

Sep 08, 2007 | Microsoft Office Standard for PC

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

Related Topics:

34 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...