Copying decimal data to another column to integer 'on the fly'

  • Thread starter Thread starter mitchjoh
  • Start date Start date
M

mitchjoh

Hi,

I am working on Asset registers/Depreciation Schedules and at the star
of the year I need to convert over my previous years spreadsheets (fo
about 40
schools) to the new financial year. This means moving the accumulate
depreciation at the end of the previous year to being the 'openin
depreciation' for the new year.

I therefore want to copy a column of figures to another column an
paste to that column as values only BUT as INTEGERS.

I am running Excel 2003 - 'Paste Only' can solve the 'values' part bu
does not have conversion to an integer 'on the fly'.

Dooe anyone have any suggestions?



John Mitchel
 
Hello John,

Either select the entire Column or the Cells where the data will b
Pasted and Right Click the mouse. This will display a menu. Select th
Format Cells option. Change the format by Left Clicking the Number Ta
in the Format Cells dialog window. In the Category list select "Number
and then change the decimal points shown to zero. This effectivel
converts the number to an Integer. However, Excel will round the value
up or down accordingly.

If you want the number to be a plain Integer (strip off the cents) thi
will require writing a macro since Excel rounds off everything. If yo
need a macro, let me know. You can repost or email me a
(e-mail address removed).

Sincerely,
Leith Ros
 
my reccomendation is to:

a) not use Excel for database purposes.
b) not use Excel for database purposes.
and
c) not use Excel for database purposes.

Access-- or better yet-- SQL Server would make your data USABLE
 
Back
Top