Results 1 to 3 of 3

Thread: cell rounding of value automatically

Threaded View

  1. Apr 14th, 2005, 09:52 AM #1
    vb_student
    vb_student is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jan 2005
    Posts
    1,069

    Resolved cell rounding of value automatically

    Hello
    i am working on this worksheet, and it is rounding off the value in certain cells automatically.
    e.g. if i have a value 2.98 in cell c3 and i make the value of the cell in question say c56 =c3
    it gives a value of 3

    actually i discovered that the cell does not like any fractional number, if i directly try to input 3.1 it rounds it of to 3
    Last edited by vb_student; Apr 15th, 2005 at 06:02 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width