Microsoft Excel for PC Logo

Related Topics:

Posted on Feb 04, 2009
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

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

  • 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

David Shaub

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,994 Answers
  • Posted on Feb 04, 2009
David Shaub
Microsoft Master
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.

Joined: Jan 01, 2009
Answers
2994
Questions
2
Helped
1153345
Points
8370

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

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

0helpful
1answer

When I type a number - say 4 -and hit return it changes to 0.04. How do I prevent this?

right click on the cell your are typing into, and check the format 'Format Cells' - change the format to 'General' - or choose another format. Highlight a row/column or several cells to change the format of them all.
0helpful
1answer

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
10helpful
3answers

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.
0helpful
1answer
1helpful
1answer

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.
0helpful
1answer

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
0helpful
1answer

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...
0helpful
1answer

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.
0helpful
1answer

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.
Not finding what you are looking for?

49 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

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

Answer questions

Manuals & User Guides

Loading...