Results 1 to 2 of 2

formatting

Threaded View

  1. #1
    Registered User
    Join Date
    12-18-2011
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    3

    formatting

    Dear excel-perts

    I have a lot of cells containing positive numbers upto 6 decimal places in brackets. How can I most easily convert them such that they remain in brackets but with precision upto only 3 decimal places? For those cells containing numbers that are not within brackets I can format them easily as they are numeric...

    In fact I also have cells in which numbers (may be positive or negative) might be succeeded by asterisk (*). I would like to reduce the precision of these numbers to 3 decimal places as well.

    Many thanks and cheers
    Abhimanyu
    Last edited by aarora87; 12-18-2011 at 01:54 PM.

Thread Information

Users Browsing this Thread

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

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