View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tilt64 tilt64 is offline
external usenet poster
 
Posts: 1
Default Cutting off numbers to two decimal places using a SCRIPT

Hi, I would like to know if any of you would know how to change the cel
contents in the following situation:
I enter 2.1342
I want excel to change it to 2.13
not just changing the formatting, but actually changing the number t
round to the hundreths place. When I go back to that cell, I don'
want to know that there was ever a number there besides 2.13, does tha
make sense? I want it to edit my number for me.
Thanks ahead of time,
We

--
Message posted from http://www.ExcelForum.com