Format Data Entry

  • Thread starter Thread starter Ayuda
  • Start date Start date
A

Ayuda

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.
 
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.
 
Back
Top