Results 1 to 11 of 11

Query in formatting of excel

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Arrow Query in formatting of excel

    In excel file have i data where data is written as below mentioned.
    so can i change this cell where Cr. data should be in positive and Dr. should be in negative (-).

    Sales Accounts 5000.00 Cr
    Direct Expenses 3254.00 Dr
    Indirect Incomes 15246.00 Cr
    Indirect Expenses 246568.00 Dr

    Thanks in advance
    Attached Files Attached Files
    Click on (*), if you agree.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel query problems with VBA/ADO to iSeries... date formatting, pass variable w/ quotes
    By anthallen_dps in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-04-2013, 05:08 PM
  2. Formatting not preserved in web query Excel 2007
    By Methodician in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 01:36 PM
  3. Excel query related to Bold function in formatting
    By vjharry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-18-2013, 08:22 AM
  4. Excel 2000 conditional formatting query
    By Nemesis_252 in forum Excel General
    Replies: 10
    Last Post: 07-09-2010, 04:43 AM
  5. Microsoft Query from Access to Excel formatting issue
    By Lloyddobler in forum Excel General
    Replies: 1
    Last Post: 09-24-2009, 03:20 PM
  6. Replies: 0
    Last Post: 02-10-2009, 02:41 PM
  7. access query reports to excel formatting help
    By fastmike in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-25-2006, 10:50 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1