Thread: Decimal Places
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rab Swinney Rab Swinney is offline
external usenet poster
 
Posts: 1
Default Decimal Places

How do I remove a decimal place to return the following

0900.000 to 0900000
I know I can use the left and right function and & them, the problem is the
first 4 digits can be 5 or 6 digits