View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary C Gary C is offline
external usenet poster
 
Posts: 5
Default Import Qucikbooks Problem - formatting

That particular cell shows 6101.75. Realize that is one example of 390
entries in that column.



"Dave O" wrote:

Excel may be interpreting the colon as a delimiter as in a time
display. What displays in the cell? You want to see 6000:6105, but
what does Excel show? I'm sure there's a workaround.