Thread: What format should I use to display 1.1.01 as 1.1.1 ?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default 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?


Reply With QuoteReply With Quote