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

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

My Phone Screen Wont Turn On, Even When I Put It On The Charger


Hi take off your memory card and format it 3times, by the way you should do same format for your cellphone. It is a software problem.cheers

Nov 25, 2013 | ZTE Score

1 Answer

Thomson gateway tg585


yes i need my password or linksys wirless-g broadband router i need doe code ? pls give me now

Sep 03, 2013 | Linksys Wireless-G Broadband Router

3 Answers

My nokia x3 wont start after showing the nokia logo, blinked 4 times with white screen and its goes off.WHY


Remove the battery and the SD memory card, check the card for corrupt/virus infected files that have corrupted the software. Now have it scanned on your PC and remove/format the card.
Reset to the phone and check , if the fault comes back then the software must be installed on the phone. have this done at the Nokia care/support center.

Jan 17, 2011 | Nokia X3 Cell Phone

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

Why when i format my memory card itsay eror ocur operation cancel


it should be possible that some type of virus occour in your phone memory so firstly plz format your mobile with putting this code. but plz. remove your mmc card and sim card before doing this and keep a phone book number back up in your sim card because during formatting your entire contact details and images and messages were deletd. code is *#7370# and password is (nokia by default) 12345. only type this code in your mobile fone. after that plz. format your mmc card with a help of virus free computer after that put mmc card in tha mobile. thanks
rgrds: Rajiv kumar 9811461147

Mar 27, 2009 | Nokia 6600

1 Answer

Windows wont boot up


try to choose repair after you are booting from cd ...like you re-install it ...but choose repair at the second time ...after the system files are loaded ...after this ...just type the ..fixboot command ...or choose a command from the list by pressing f1 ( probably...there are guiding choices anyway...) my solution is to reinstall it ...and format the C partition ..its the safest way..and easier..one too..if you dont want to loose any data from this partition ..install it in the same folder first ..without format it ....move all data to D partition ..then reinstall a clean windows ..by formating the C partition...this will asure you a safe future run...

Mar 21, 2009 | Acer Aspire 3610 Notebook

1 Answer

Battery gets discharged


Possible Problems:
1. Maybe there's a virus.
2. Often restart can drain the battery.

Possible Solution:
Format it by pressing the green key or call key + no. 3 + asterisk(*) at the same time. But 1stly, turn off ur fone, then b4 the NOKIA logo appears, hold these following keys altogether. You will see the "Formatting" word afterwards..
OR...
Format it by typing *#7370.

Aug 03, 2008 | Nokia 3230 Cellular Phone

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 | Computers & Internet

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 Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

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