WeThotUWasAToad
asked on
Display decimal value without leading zero
How do you display a decimal value (eg three-digit ratio or percentage) without the leading zero?
For example, a baseball batting average is typically displayed as .315 rather than 0.315. However, I cannot get Excel to display the former without changing to Text mode (which I do not want to do).
Thanks
For example, a baseball batting average is typically displayed as .315 rather than 0.315. However, I cannot get Excel to display the former without changing to Text mode (which I do not want to do).
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Pleasure!
Thanks, and thanks Joe. You did a way better job of clarifying.
Hi Tom,
I appreciate the compliment! Regards, Joe
I appreciate the compliment! Regards, Joe
ASKER