View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?