| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why do my numbers keep going down decimal places? | Setting up and Configuration of Excel | |||
| Why do my numbers keep going down decimal places? | Setting up and Configuration of Excel | |||
| Sum of numbers with only two decimal places wrong | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Trim numbers to x decimal places | Excel Programming | |||
Threaded Mode
