| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Set automatic currancy decimal without entering the decimal?
On calculators, one can set it for always placing a two place decimal.
Therefore, I do not have to to hit the decimal when adding a currancy column. The two place decimal is automatic. If there is no cents, one enters 2 zeros. Can the computer be set for that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Set automatic currancy decimal without entering the decimal?
Hi,
format the cell as currency and decimal places are automatically added or if you don't want a currency format then use number and you get the same but without the currency symbol. Mike "Giesej" wrote: On calculators, one can set it for always placing a two place decimal. Therefore, I do not have to to hit the decimal when adding a currancy column. The two place decimal is automatic. If there is no cents, one enters 2 zeros. Can the computer be set for that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Set automatic currancy decimal without entering the decimal?
Thank you. However, I still have to hit the decimal for inputing the cents.
"Mike H" wrote: Hi, format the cell as currency and decimal places are automatically added or if you don't want a currency format then use number and you get the same but without the currency symbol. Mike "Giesej" wrote: On calculators, one can set it for always placing a two place decimal. Therefore, I do not have to to hit the decimal when adding a currancy column. The two place decimal is automatic. If there is no cents, one enters 2 zeros. Can the computer be set for that? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Set automatic currancy decimal without entering the decimal?
Hi,
Choose Tools, Options, Edit, and check Fixed decimal and leave 2 in the Places box. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Giesej" wrote: Thank you. However, I still have to hit the decimal for inputing the cents. "Mike H" wrote: Hi, format the cell as currency and decimal places are automatically added or if you don't want a currency format then use number and you get the same but without the currency symbol. Mike "Giesej" wrote: On calculators, one can set it for always placing a two place decimal. Therefore, I do not have to to hit the decimal when adding a currancy column. The two place decimal is automatic. If there is no cents, one enters 2 zeros. Can the computer be set for that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering a whole number e.g. 4, results in a decimal entry, 0.04 | Excel Discussion (Misc queries) | |||
| Unwanted decimal places when entering integers | Excel Discussion (Misc queries) | |||
| Format option for decimal. e.g., entering 531 results in 5.31 | Excel Discussion (Misc queries) | |||
| position of decimal point when entering a number ... | Excel Discussion (Misc queries) | |||
| Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
Linear Mode
