View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephen
 
Posts: n/a
Default 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.