ExcelBanter - Decimal point location

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Decimal point location (https://www.excelbanter.com/excel-discussion-misc-queries/208919-decimal-point-location.html)

Danny boy

Decimal point location

Hey
Want my number to appear like this .1250 not 0.1250
How do i remove the zero befor the decimal point

Gary''s Student

Decimal point location

Format Cells... Number Custom .00000
--
Gary''s Student - gsnu200811

Bernard Liengme

Decimal point location

With a custom format such as .0000
I have always considered it dangerous to drop the leading zero except for
gun calibres.
So I hope you and other readers have good eyesight and do not misread the
values
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Danny Boy" wrote in message
...
Hey
Want my number to appear like this .1250 not 0.1250
How do i remove the zero befor the decimal point

All times are GMT +1. The time now is 04:45 PM.