Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I try to enter info in a cell - type 0.77 and it changes to 1. How do I
change it back? |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Anoli
Look at Tools/Options/Edit Make sure "fixed decimal places" is not checked Also, check the cell format, may be Number/No decimal places or Custom/ 0 Beege "Anoli" wrote in message ... I try to enter info in a cell - type 0.77 and it changes to 1. How do I change it back? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You could try increasing the number of decimal places displayed.
Click on the Increase Decimal icon on the Formatting Menu bar a couple of times. Note: a more specific description of your problem would get more people to look and maybe respond. Regards Trevor "Anoli" wrote in message ... I try to enter info in a cell - type 0.77 and it changes to 1. How do I change it back? |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Reformat the cell to format 0.00.
"Anoli" wrote in message ... I try to enter info in a cell - type 0.77 and it changes to 1. How do I change it back? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|