> Helpdesk

Helpdesk Hours:

Peavy-Richardson
Helpdesk

Monday-Friday:
8:00am - 6:00pm

Contact Info:

Telephone:

(541) 737-2152

Forestry Computing Helpdesk

Notifications

Welcome to the College of Forestry Computing Helpdesk. There are no new notifications at this time. Please check back regularly for updated news on helpdesk events, network and support issues, and web development.

· · ·

Excel: Text to Numbers and Numbers to Text

One good way to convert text to numbers is --
Copy a blank cell to the clipboard
Select the range to convert
Edit | Paste Special (and select the function Add, copying your blank cell to the selected range)

This will force Excel to treat the blank cell as zero and the text cells as numbers to do the arithmetic add function. The result is saved as a number.
The TEXT function will convert numbers to text (in another column).
For example, you will convert numbers in Column A to three digit text numbers with leading zeros if you use something of the form,
=TEXT(A2,"000")
Copy | Paste Special (as Values) can be used to replace the original numbers with Text.
And if you want leading zeros but need the number to still be a number, use
Format | Cells | Custom | 000 (as the format text for three digits)

· Software How-Tos

· Helpdesk Forms

· Macintosh Documentation

· Computer Buying Guide

· Spatial Data Management
Group Webpage

· OSU Computer Helpdesk

Forestry Computing Helpdesk, Peavy Hall 222
Oregon State University, Corvallis, OR 97331 | (541) 737-2152
Contact us with your comments and questions | About this site
Copyright © 2003 Oregon State University | Disclaimer

The current number of problems in the database is:
49