+ Reply to Thread
Results 1 to 2 of 2

Excel Numeric formating

  1. #1
    Registered User
    Join Date
    11-22-2006
    Posts
    5

    Excel Numeric formating

    Hello,

    Is it possible to do an actualy convert of a number such as 2.33333 to 2.33 in excel? I know I can format the numbers this way but I am looking to physically change.

    I hope this makes sense.

    Thanks

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,824
    Have you tried using the ROUND(), ROUNDDOWN(), ROUNDUP(), FLOOR(), CEILING(), TRUNC(), etc. functions?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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