Can I do a bulk truncate or int() in Excel? 1

[jsteph]

Hi all,
I have a range of cells where the data is decimal format. I want to convert *the data* (not the format), so that the actual cell contents are their truncated numeric versions. In other words, 21.1 or 21.9 both become 21 no decimal point.

Is this possible to do in a single (or in a few-steps) operation?
Thanks,
--Jim

 

[SkipVought]

Hi,

In an empty column..
[tt]
=INT(the date ref)
[/tt]
copy down.

copy the column

select the date column

Edit > Paste Special -- VALUES

VOLA, y'all!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jsteph]

Yep, that did it, thanks!