Format Data Entry
Is there a way to format data so that when entering someone's height as 511
it will come up as 5'11" and when entering 63 it would come up as 6'3" ? Thanks. |
Format Data Entry
There may be a way, but I wouldn't do this.
Instead, use two cells (feet and inches). Or use one cell and enter total inches. It'll make any further arithmetic much, much easier. Ayuda wrote: Is there a way to format data so that when entering someone's height as 511 it will come up as 5'11" and when entering 63 it would come up as 6'3" ? Thanks. -- Dave Peterson |
All times are GMT +1. The time now is 06:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com