View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beebs
 
Posts: n/a
Default defined cell as currency but still have to enter decimal point

Is there a way to enter in dollar amounts and have the software assume a two
diget decimal point without having to actually enter in the dec. point. I
have defined the cell as currency and defined 2 dec. positions. Also defined
as accounting with 2 dec. positions. When I enter in 1234 it comes out
1,234.00.
Any help here?