Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2000 Measurement Units

Status
Not open for further replies.

lamaar

Technical User
Jun 29, 2000
392
GB
How do I change the measurement units from CM to Inches in Excel 2000. I can do it in Word 2000. Do it have something to do with reginal settings?

Regards Lamaar75@hotmail.com
 
Not sure what you mean. I am not sure what you want to do, but have you thought about using CONVERT?

It converts a number from one measurement system to another.

If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using Add-Ins on the Tools menu.

This is the usage:

CONVERT(number,from_unit,to_unit)
 
Basically, what I wanted was as follows:

If I create a text box and look at it's formatting - it is set to Centimetres - I want it in Inches. Where do I change this? Lamaar75@hotmail.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top