| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Truncating entire worksheet
I have a budget worksheet which gets loaded into our main database system.
THe numbers in the worksheet have nummbers beyond the decimal(123.34) In order to load intoour system, all the numbers need to zero (123.00). Any thoughts on an easy way to do this? I have 15 sheets with 300 line items each. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
| Extracting data from one Worsheet to Another Worksheet with common link value | Excel Discussion (Misc queries) | |||
| Macro that double spaces rows for an entire worksheet? | Excel Discussion (Misc queries) | |||
| How do I change uppercase to proper case in entire worksheet? | Excel Worksheet Functions | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Threaded Mode
