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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER