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

I am using Excel 2011 for Mac

Posted by on

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

Welcome Back:

Visited the website for 2 consecutive days.

• Contributor

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.

Posted on Apr 30, 2017

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)
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

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

### Amazon.com: Excel for Mac 2011

Amazon.com, Inc.Excel for Mac 2011 lets you create easy-to-analyze spreadsheets you can ... MicrosoftOffice Home and Student 2016 for Mac ' Mac Key Card ... Learn More; ASIN: B003YCOJBC; Item model number: D46-00803; Date first .... Imagine my surprise when the Excel installation disk would not load on my Mac Mini's DVD drive.

### Amazon.com: Customer Reviews: Excel for Mac 2011

www.amazon.com/Microsoft-D46-00803-Excel...201...

Amazon.com, Inc.Find helpful customer reviews and review ratings for Excel for Mac 2011 at Amazon.com. ... Desktops & Monitors Computer Accessories & Peripherals Externaldrives, .... I, too, much preferred Windows version of MS-Office 2003 over Windows ....when the Excel installation disk would not load on my Mac Mini's DVD drive.

### ms excel mac 2011 english dvd [d46-00803] - Computer ...

www.cworld.com.au > Software and Licensing > Retail Software
MS EXCEL MAC 2011 ENGLISH DVD [D46-00803]

Jan 05, 2016 | Microsoft Office Computers & Internet

### Restrict permission to content in a file - Office Support

https://support.office.com/.../Restrict-permission-to-content-in-a-file-3cd...
My accountSign in ... Which Office program are you using? Word. PowerPoint. Excel... to content in a file, you have to have Microsoft Office for Mac Standard 2011. ... Authors can use the Set Permissions dialog box to set expiration dates for ...

### Restricting changes by using read-only status - Office Support

My accountSign in ... Which Office program are you using? Word. PowerPoint. Excel... only the owner or those with Write privileges can remove the designation. ... Applies To: PowerPoint for Mac 2011, Word for Mac 2011, Excel for Mac 2011.

Jan 05, 2016 | Microsoft Excel for Mac 2011 D46-00803

### How do I put an apple laptop ibookG4 back into normal mode

Restart holding down: command option O and F. Keep holding down those 4 keys until you see text on a light background. At the end of the text will be 'release keys to continue'. Release the 4 keys and type: reset-nvram hit return, then type: set-defaults hit return, then type: reset-all and hit return. The iBookG4 should restart with all default settings restored.

Oct 20, 2014 | Apple G4 Computers & Internet

### I am not able to open microsoft excel application. THE FIRST BOX THAT POPS UP: The application Microsoft Excel quit unexpectedly. Mac OS X and other applications are not affected. Click Relaunch to...

I would uninstall it and reinstall again. If that doesn't fix it, uninstall it and use Open Office instead. Far better, free open access and easier to use plus fully compatible with any microsoft stuff.

Mar 01, 2017 | Microsoft Excel Mac for Mac

If you're running Jaguar, and you know your short user name (the same as your home folder name) you can do the following.

1) boot into single user mode (boot holding Apple + S)
2) type "fsck -y" and hit enter/return
3) repeat step 2 until it says that "The volume [your hard drive name] appears to be OK"
4) type "mount -uw /" and hit enter/return (this mounts the hard drive)
5) type "SystemStarter" and hit enter/return (this will start up quite a bit, including NetInfo, which is what you need)
7) enter your password, and hit enter (you won't see it typing)
8) verify your password, and hit enter (again, you won't see it being typed)
9) type "reboot" and hit enter

May 08, 2010 | Apple iBook G4 Mac Notebook

### I have a g 4 and can not remember my password

restart your computer. When the first white screen comes up, hold down command+s keys. the screen will change to white on black and some code writing will load. DONT FREAK OUT OR PRESS ANYTHING UNTIL AT THE BOTTOM OF THE SCREEN IT SAYS "root". then type in exactly:"/sbin/mount -uw /" hit return once then type in "passwd [username]" and hit return. where it says "type in new password" type in the password u want. hit return and retype the password. hit return one more time and wait for the codes to say "root". then type in "exit" and hit return. the computer should continue to start up and u should be able to log in.

Mar 05, 2010 | Apple Powerbook G4 17" 1.67 GHz SuperDrive...

### Using excel to solve problem by trial and error method

In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

### Used Mac software update on a G4 portable two weeks ago and now when I use it it hangs. Any way to fix this problem??

Hi, Sorry you are having problems,
Try this:
restart your Mac, and VERY QUICKLY, press the following 4 keys and hold them until the mac does a restart 4 times, it is called resetting the PRAM:
cmd + alt + P + R
then, after 4 startup chimes,
switch to these 4 buttons:
cmd + alt + O + F
you will enter the Open Firmware interface.
type this, exactly:
reset-nvram then hit return
reset-all then hit return
then, VERY QUICKLY, hold down the shift key ( not caps lock, but caps ) and hold it until the mac stats to boot, you see the progress wheel under the grey apple logo, this is called booting with extentions disabled,
the boot up process is much Much longer than usual, it is performing a fsck disk repair
Then, Log in and run disk utilities and repair the permissions, do it over and over again until there are no errors...
Also, verify the disk to see if there are any obvious disk problems.
Then, once that is all done and there are no disk errors, SHUT DOWN your mac and then boot it up normally, .....
See if that helps.....
If it does not help, you are going to have to re-install Mac OS using the archive and install feature.
Good luck.

Mar 29, 2009 | Apple PowerBook G4 Mac Notebook

Oct 02, 2007 | Targus USB Ultra Mini Keypad Keyboard...

## Open Questions:

#### Related Topics:

32 people viewed this question

Level 3 Expert

Level 3 Expert