| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
What format should I use to display 1.1.01 as 1.1.1 ?
=SUBSTITUTE(A1,"0","")
-- Gary''s Student - gsnu200837 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display the value in different format? | Excel Discussion (Misc queries) | |||
| Display #'s incorrectly (format) | Excel Discussion (Misc queries) | |||
| Display time format | Excel Discussion (Misc queries) | |||
| How to display 5 into May in mmm format? | Excel Discussion (Misc queries) | |||
| Display 0's in Accounting format | Excel Discussion (Misc queries) | |||
Linear Mode
