Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel, how do I display a leading zero? e.g. 05 for 5 ?
Am using Excel to calculate a pace-per-mile for runners, starting with "miles
per hour". 7 mph is an eight minute and 34 second "pace per mile". I start with 7.0 mph in the initial column, and can easily calculate the 8:34. But 6.6 mph is 9 minutes and 5 seconds per mile, which I can calculate. I have the 9 in one column and the 5 in another, and use CONCATENATE to display it as 9:5. But I want it to display as 9:05, not 9:5. How do I get that leading zero in there? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Leading Zero | Excel Discussion (Misc queries) | |||
Display leading zeros in numeric value without converting to text | Excel Discussion (Misc queries) | |||
Display Binary Leading Zeros | Excel Discussion (Misc queries) | |||
how do you display a zip code with a leading zero | Excel Discussion (Misc queries) | |||
How do I display leading zeros so I can export a fixed in Excel? | Excel Discussion (Misc queries) |