| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
The number I type in a cell, e.g. 500, appears at 0.5 - why?
If I type, for exampe, 500 into an excel cell it appear as 0.5 when I press
enter. How do I stop this from happening? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The number I type in a cell, e.g. 500, appears at 0.5 - why?
Becky Wrote: If I type, for exampe, 500 into an excel cell it appear as 0.5 when I press enter. How do I stop this from happening? Thats A good one , I couldn't find a format that would do that, anyway, you should be able to fix it if you format your cell Right click on the mouse, select format cells select the numbers tab Numbers select the format you want for the cell -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=523033 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The number I type in a cell, e.g. 500, appears at 0.5 - why?
"Becky" wrote in message
... If I type, for exampe, 500 into an excel cell it appear as 0.5 when I press enter. How do I stop this from happening? Tools/ Options/ Edit Make sure "Fixed decimal places" is unchecked. -- David Biddulph |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The number I type in a cell, e.g. 500, appears at 0.5 - why?
"davesexcel" wrote
in message ... Becky Wrote: If I type, for exampe, 500 into an excel cell it appear as 0.5 when I press enter. How do I stop this from happening? Thats A good one , I couldn't find a format that would do that, anyway, you should be able to fix it if you format your cell Right click on the mouse, select format cells select the numbers tab Numbers select the format you want for the cell If you want to make it do that, dave, try Tools/ Options/ Edit: "Fixed decimal places" checked & set to 3. And, as far as I am aware, setting the numbers format for the cell won't cure it. The cure, if that is the problem, is to clear the "Fixed decimal places" check box. -- David Biddulph |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
The number I type in a cell, e.g. 500, appears at 0.5 - why?
Oh Yes, There it is, Thanks -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=523033 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Counting the number of times a specific character appears in a cell | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Can Excel add a set percentage to a cell automatically when you type in a number | Excel Worksheet Functions | |||
Linear Mode
