View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dcsawyers dcsawyers is offline
external usenet poster
 
Posts: 2
Default Is there a Custom Format to Format 11168 as 111.68?

I'm importing a text file with a lot of numbers in the format of XXXXX and
want to format them as XXX.XX without having to divide all the numbers by 100
and then place in a separate column. Is there a way to create a custom
format that will do this for me?