Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Desperate School Secretary
 
Posts: n/a
Default How do I get numbers on a colum to stay as I typed them on an exc.

I created a workbook with information to be used for merging to a letter. I
created a heading colum to read "HOURS" and entered the numbers as 1:23.
When I merged the files, the information showed at 1:23:00 A.M. How do I
correct this on my workbook excel file or on the Word document? I do not
want the numbers to be changed to time. Please help!!!!!!
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx


Desperate School Secretary wrote:
I created a workbook with information to be used for merging to a letter. I
created a heading colum to read "HOURS" and entered the numbers as 1:23.
When I merged the files, the information showed at 1:23:00 A.M. How do I
correct this on my workbook excel file or on the Word document? I do not
want the numbers to be changed to time. Please help!!!!!!



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
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
Match Last Occurrence of two numbers and Return Date Sam via OfficeKB.com Excel Worksheet Functions 6 April 5th 05 12:40 PM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
Count and Sum Total occurrances of two specific numbers Sam via OfficeKB.com Excel Worksheet Functions 10 March 29th 05 08:13 PM
how do I put in line numbers in the first colum starting in row A. Bernie Excel Discussion (Misc queries) 2 January 12th 05 11:07 PM
How do I enter a prefix number to a colum of numbers Newbee101l Excel Worksheet Functions 3 November 19th 04 05:07 PM


All times are GMT +1. The time now is 03:10 PM.

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"