Thread: Entering a dollar amount w/out having to enter the decimal
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
  
Posts: 2,389
Default Entering a dollar amount w/out having to enter the decimal
It's one of the options you can specify. In Excel 2007, it's:
Excel Options...AdvancedAutomatically insert a decimal point

Regards,
Fred

"Julieanne" wrote in message
...
What is the formula to have Excel automatically enter the decimal so all I
have to enter is the numbers?

Reply With QuoteReply With Quote