ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel cell formatting (https://www.excelbanter.com/excel-programming/321908-excel-cell-formatting.html)

pwesthelle

Excel cell formatting
 
Would like to see a distance number cell formatting category. One that
allows any numerical to be expressed in terms of feet and inches -- or other
units of measurement. It should also should allow for metric to English
conversions, or vis-versa. An anlagous set of formats for weights and
measures would also be great.

Mike Fogleman

Excel cell formatting
 
It's not for Excel, but it is a great unit conversion program called
Versaverter. Get it free here
http://pawprint.net/vv/

Mike F


"pwesthelle" wrote in message
...
Would like to see a distance number cell formatting category. One that
allows any numerical to be expressed in terms of feet and inches -- or
other
units of measurement. It should also should allow for metric to English
conversions, or vis-versa. An anlagous set of formats for weights and
measures would also be great.




Orision

Excel cell formatting
 
I tihnk that giving us some way to write our own njumber formats using
formulas that apply to that particular call would be really handy. Then we
would write out own cell formats for our preferences. As it is, we couldn't
even create a date system that applies to the current cell, we have to use
the one built into excel.

"pwesthelle" wrote:

Would like to see a distance number cell formatting category. One that
allows any numerical to be expressed in terms of feet and inches -- or other
units of measurement. It should also should allow for metric to English
conversions, or vis-versa. An anlagous set of formats for weights and
measures would also be great.


firefytr[_2_]

Excel cell formatting
 

There is also the CONVERT function in Excel, which can handle som
conversions

--
firefyt

-----------------------------------------------------------------------
firefytr's Profile: http://www.excelforum.com/member.php...nfo&userid=664
View this thread: http://www.excelforum.com/showthread.php?threadid=34012



All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com