LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,069
Default simple currency addition in cell without having to enter decimal

I want to add dollar amounts in an individual cell with a fixed decimal
point. In other words, click on a single cell, press =, then enter multiple
numbers (preceeded or followed by the + or - sign) without having to enter
decimal for each amount entered.

I have worn myself out trying to format a cell to perform this way but
haven't conquered it yet. Even though it works fine when entering a single
number in a cell, it doesn't work when entering multiple numbers this way in
a single cell. As soon as I press = in the cell, all numbers display without
a fixed decimal point. I have to enter it manually and do not want to have
to do so.

Thanks in Advance,
John Couch
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Stop next cell being selected on Enter Ken G. Excel Discussion (Misc queries) 2 December 6th 05 07:21 AM
Stop next cell being selected on Enter Jeff Stevens Excel Discussion (Misc queries) 0 December 6th 05 06:55 AM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 02:06 AM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"