LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 37
Default Number Formatting Issue

Hello,

I download a monthly report that contains all of our departments incoming
call volume. One column is the duration formatted as 0:01:09. When I try to
do a sum I get a zero. I've tried different formatting and text to column
and have to resort to copying that column into Word then doing a copy/paste
special as text back into Excel for the sum function to work properly. Any
suggestions?

Thank you!!
Cathy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CSV formatting issue sueasmith31 Excel Discussion (Misc queries) 1 May 19th 09 08:00 PM
Formatting issue Ramone Excel Discussion (Misc queries) 1 February 19th 07 02:50 AM
Formatting issue ??? yarrakid Excel Discussion (Misc queries) 0 June 13th 06 09:31 AM
formatting issue? chip_pyp Excel Discussion (Misc queries) 4 January 31st 06 09:22 PM
Number formatting issue Gayle Excel Worksheet Functions 2 August 8th 05 08:51 PM


All times are GMT +1. The time now is 01:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"