|
· · ·
|
|
- 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
|