Preceding zeros
Preceding zeros
(OP)
Does anyone know a setting to tell Excel to not display zeros preceding a decimal point e.g. to display 0.12 as .12? I'd like to make it a permanent change in Excel because the preceding zero is not in accordance with US practice.
Tunalover





RE: Preceding zeros
RE: Preceding zeros
But if you want to you can define a custom format in the form "#.00" and when you pick that custom format the leading zero won't be there.
You can go into Format, Style, and modify the "Normal" style to have that "#" before the decimal, but I don't know how to apply that to the global format.
David
RE: Preceding zeros
Tunalover
RE: Preceding zeros
RE: Preceding zeros
I do always use the leading zero, even in hand calculations because it adds clarity and makes it harder to accidentally miss the decimal point, especially if I think someone else may need to read it later. What are the benefits of dropping that leading zero?
RE: Preceding zeros
RE: Preceding zeros
Huh ???? .... since when??????
As far as ASME Y14.5M-1994, you are correct, but in the world of science & mathematics ....
"from the Style Guidelines for the Journal of Regional Science"
Remember...
"If you don't use your head,
your going to have to use your feet."
RE: Preceding zeros
RE: Preceding zeros
Format | Cells | Number
Select custom, delete the leading zero in the box.
RE: Preceding zeros
RE: Preceding zeros
It looks as if you can change the defaults for just about anything in new books and sheets ref.
http://www.meadinkent.co.uk/xlconfigure.htm
but long live leading zeroes.
regards Hugh
RE: Preceding zeros
RE: Preceding zeros
RE: Preceding zeros