ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get numbers on a colum to stay as I typed them on an exc. (https://www.excelbanter.com/excel-discussion-misc-queries/20845-how-do-i-get-numbers-colum-stay-i-typed-them-exc.html)

Desperate School Secretary

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!!!!!!

Debra Dalgleish

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



All times are GMT +1. The time now is 04:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com