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.

Truncating entire worksheet
 

First-SAVE
Then, try this:

EditReplace
Find what: .*
Replace with: (leave this blank)
Click the [Replace All] button

Caveat: That will find all decimal points and truncate everything from the
decimal point, inclusive. If you have a paragraph with a period....everthing
from the period will be deleted. If that situation exists...select only the
impacted numeric cells then perform the Edit/Replace.


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Stephen" wrote:

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.