What format should I use to display 1.1.01 as 1.1.1 ?
 

What format should I use to display 1.1.01 as 1.1.1 in a cell?

What format should I use to display 1.1.01 as 1.1.1 ?
 

It is text, formats work on numbers.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"MoJo" wrote in message
...
What format should I use to display 1.1.01 as 1.1.1 in a cell?

What format should I use to display 1.1.01 as 1.1.1 ?
 

=SUBSTITUTE(A1,"0","")
--
Gary''s Student - gsnu200837

What format should I use to display 1.1.01 as 1.1.1 ?
 

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)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"MoJo" wrote in message
...
What format should I use to display 1.1.01 as 1.1.1 in a cell?

What format should I use to display 1.1.01 as 1.1.1 ?
 

This is probably safer:

=SUBSTITUTE(A1,".0",".")

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Gary''s Student" wrote in message
...
=SUBSTITUTE(A1,"0","")
--
Gary''s Student - gsnu200837