Post Your PC Questions

Site Index   |  Quick Index   |  New Tips   |  MS Windows   |  MS Office   |   Newsletter   |   Q&A  |   More Tips  |    

Tips Download   |   Donations   |   Customer Support   |   Registry Tips   |   Weekend Windup |   IE 6.0   |   IE 7.0  |   Help   |   Suggestions

 Windows XP Run Commands | Computer Questions. Microsoft Access Databases | Computer Terms | New Home Material Estimating Spread Sheets!

  Windows XP Remote Desktop Setup One! | 57 Vista Run Commands | Windows XP Remote Desktop Setup Two!

See The 11 Tip Package That You Should Print And Keep Close To Your Computer!   This One Comes With The Standard Tips Package!  Two Downloads!

Internet Fixes Computer Related FAQ. News Feed RSS   TOP 10 Questions Feed RSS   My Blog!

Internet Fixes

 

Changing Text to Numbers Part 1

Sometimes when you import files from other sources, numeric values may appear to be numbers but act like text values. To resolve this behavior, convert these values into numbers. One method for doing this is to multiply these text values by 1. To convert the text values, follow these steps: 

1. Click a blank cell in the worksheet and make sure that the cell is not formatted as text. Then type 1 in the cell. 

2. With that cell selected, click Copy on the Edit menu. 

3. Select the range that contains values you want to convert to numbers. 

4. Click Paste Special on the Edit menu. 

5. Under Operation, click Multiply, and then click OK. 

This method converts the text to numbers. You can tell whether you successfully converted the text values by viewing the alignment of the number. If you use the General format and the values are aligned to the right, the values are numbers; text values are aligned to the left.

<<<Back Home Next>>>

Hit Counter

Main Site Navigation:

See The 11 Tip Package That You Should Print And Keep Close To Your Computer! 

This One Also Comes With The Standard Tips Package!  2 Downloads!

Internet Fixes Computer Related FAQ. News Feed RSS   TOP 10 Questions Feed RSS   My Blog!
Newsletter Signup
   |   Search   |   Windows Versions   |   Office Versions   |  
Forum |   Readers Q&A   |   Tips In Full Graphics   |   Tips Download    

 Site Navigation:
Donations
   |   Support   |   Registry Tips   |   Weekend Windup   |   PC Questions |   IE 6.0   |   IE 7.0   |   Outlook Express 6.0   |   PC Help
Virus Info
   |   Computer Drivers   |   Hardware Info.   |  
Your Suggestions |   IE 7.0 Install  |   Database Downloads   |   Home  |  Computer Terms  

|   57 Vista Run Commands   |   Windows XP Run Commands  |   Microsoft Access Databases  |

Windows XP Remote Desktop Setup One! |New Home Material Estimating Spread Sheets! Windows XP Remote Desktop Setup Two!

All products mentioned are registered trademarks or trademarks of their respective companies.
Questions or problems regarding this web site should be directed to the
Webmaster.
Copyright © 1999-2008  Internet Fixes. All rights reserved.      
Legal Disclaimer

This Site Is Part Of The Internet Fixes Network!