Thread: Possible??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
snickers22 snickers22 is offline
external usenet poster
 
Posts: 2
Default Possible??

In one column, I have numbers with two decimal points, i.e. 55.42. In the
next column I need to take the decimal point out and add to zeros like this
"005542". Anyone know if there is a function that would do this?