| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel-formatting
Hi,
Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-formatting
Tools-Options-Edit-Fixed Decimal - Uncheck the check box or change the Places
value as "0". TGV "Chi" wrote: Hi, Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-formatting
Hi TGV,
Thank you for your help, but It didn't work, not thing happen, after I uncheck the check box. Chi "TGV" wrote: Tools-Options-Edit-Fixed Decimal - Uncheck the check box or change the Places value as "0". TGV "Chi" wrote: Hi, Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-formatting
The cell values won't change after you uncheck the FD option.
Once entered, they are fixed at that value. Re-enter numbers. Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 10:16:02 -0700, Chi wrote: Hi TGV, Thank you for your help, but It didn't work, not thing happen, after I uncheck the check box. Chi "TGV" wrote: Tools-Options-Edit-Fixed Decimal - Uncheck the check box or change the Places value as "0". TGV "Chi" wrote: Hi, Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-formatting
Hi Gord,
It works!!! Thank you for your explanation. In my case, I need only few columns, instead of whole sheet. Is there away to do that? I am using 2007 so would you please also show me where the Fixed Decimal is? Thanks Chi "Gord Dibben" wrote: The cell values won't change after you uncheck the FD option. Once entered, they are fixed at that value. Re-enter numbers. Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 10:16:02 -0700, Chi wrote: Hi TGV, Thank you for your help, but It didn't work, not thing happen, after I uncheck the check box. Chi "TGV" wrote: Tools-Options-Edit-Fixed Decimal - Uncheck the check box or change the Places value as "0". TGV "Chi" wrote: Hi, Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-formatting
Office ButtonExcel OptionsAdvancedEditing OptionsAutomatically insert a
decimal point. You would have to use event code for just a few columns. I can provide that. Which columns are you talking about? Your first post is a bit ambiguous or some of us are misreading it. What exactly do you want? Enter 100 and it becomes 10? Enter 95 and it becomes 9.5? That's what I got from your initial description. Gord On Thu, 25 Jun 2009 10:51:01 -0700, Chi wrote: Hi Gord, It works!!! Thank you for your explanation. In my case, I need only few columns, instead of whole sheet. Is there away to do that? I am using 2007 so would you please also show me where the Fixed Decimal is? Thanks Chi "Gord Dibben" wrote: The cell values won't change after you uncheck the FD option. Once entered, they are fixed at that value. Re-enter numbers. Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 10:16:02 -0700, Chi wrote: Hi TGV, Thank you for your help, but It didn't work, not thing happen, after I uncheck the check box. Chi "TGV" wrote: Tools-Options-Edit-Fixed Decimal - Uncheck the check box or change the Places value as "0". TGV "Chi" wrote: Hi, Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-formatting
Tools-Options-Edit-Fixed Decimal - Uncheck the check box or change the Places
value as "0". TGV "Chi" wrote: Hi, Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-formatting
Hi TGV,
I changed the Places value as -1 and it worked! It affected whole sheet. In my case, I only would like the numbers changed in columns D, C, and E. Thanks Chi "TGV" wrote: Tools-Options-Edit-Fixed Decimal - Uncheck the check box or change the Places value as "0". TGV "Chi" wrote: Hi, Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel-formatting
Tools-Options-Edit-Fixed Decimal - Uncheck the check box or change the Places
value as "0". TGV "Chi" wrote: Hi, Would you please show me how I can format the cells appear like the below example? Ex: if I enter to a cell 100, it will become 10 If I enter to a cell 95, it will become 9.5 And if I enter to a cell 90, it will show 9. Thanks Chi Chi |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting lost when saving excel 2003 file using excel 2007 | Excel Discussion (Misc queries) | |||
| "Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." | Excel Discussion (Misc queries) | |||
| Saving Excel 2007 conditional formatting in Excel 2003 format | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Hybrid Mode
