LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Need help with formating cell

I have a very simple worksheet with formulas. Here is what I have:

ColumnB ColumnC ColumnD
Sales Amt Sales Return Net Sales

$591518.00 $12638.00 $578880.00

My Formula for calculating Column D is: =IMSUB(B4,C4). Column B & C shows
the $ sign. When the calculation for Column D appears it does not have the
dollar sign. The entire worksheet is formatted for currency with two
decimals. I checked the individual cell and it is also formatted for
currency with two decimals. What am I missing? This is a school assignment.

Thanks


The
--
Bandit
 
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
need help formating a cell Rama Excel Worksheet Functions 3 July 22nd 08 04:14 PM
Formating cell bimseun Excel Worksheet Functions 5 June 28th 06 10:17 PM
Cell to follow content AND/OR formating of another cell 0-0 Wai Wai ^-^ Excel Discussion (Misc queries) 1 September 8th 05 02:00 PM
CELL FORMATING thom kamp Excel Discussion (Misc queries) 1 February 22nd 05 05:55 AM
Cell not formating Mojoala Excel Discussion (Misc queries) 2 January 17th 05 08:21 PM


All times are GMT +1. The time now is 05:59 AM.

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"