M
MoJo
What format should I use to display 1.1.01 as 1.1.1 in a cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
It is text, formats work on numbers.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
G
Gary''s Student
=SUBSTITUTE(A1,"0","")
B
Bernard Liengme
I don't think you can change the appearance with formatting because 1.1.01
is text not a number (or a date -- which is really a number anyway)
is text not a number (or a date -- which is really a number anyway)
J
Jon Peltier
This is probably safer:
=SUBSTITUTE(A1,".0",".")
- Jon
=SUBSTITUTE(A1,".0",".")
- Jon