Thread: Cells format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fragher75 fragher75 is offline
external usenet poster
 
Posts: 1
Default Cells format

Hi.

I have a problem. When I import a .txt file create by an accountin
software, where there are negative numbers value in this format (fo
example 150-), after the importation those numbers have a text forma
and I can't sum them with the other numbers. I have a custom forma
(#.##0;#.##0-) but I can't apply it after the importation.

Can you help me

--
Message posted from http://www.ExcelForum.com