Thread: Remove preceding zeroes?
View Single Post
  #1  
Old June 3rd, 2010, 07:24 PM posted to microsoft.public.excel.misc
hds
external usenet poster
  
Posts: 1
Default Remove preceding zeroes?
I want to enter a value as .050 x 27.5 in a cell. I can due this by
formatting the cell as text, but when I copy to a new cell I get 0.050 x
27.5. Formatting the new cell has no effect on the leading zero.
Thanks