| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does my date change to #### when i save the page?
I typed in a date, then save as and the date changed to a row of ######. I
didn't notice that the last time I entered a date on a worksheet that it did the same thing. I went into format column and it didn't help. Any ideas? Thank you for your help in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does my date change to #### when i save the page?
Maybe your column width isn't wide enough to display the full date.
Regards, Paul "Amanda" wrote in message ... I typed in a date, then save as and the date changed to a row of ######. I didn't notice that the last time I entered a date on a worksheet that it did the same thing. I went into format column and it didn't help. Any ideas? Thank you for your help in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does my date change to #### when i save the page?
It was wide enough to save all of the other dates but why not now and the
last time I entered a date? Also, when I leave the box the date will automatically change to the ####. "PCLIVE" wrote: Maybe your column width isn't wide enough to display the full date. Regards, Paul "Amanda" wrote in message ... I typed in a date, then save as and the date changed to a row of ######. I didn't notice that the last time I entered a date on a worksheet that it did the same thing. I went into format column and it didn't help. Any ideas? Thank you for your help in advance! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does my date change to #### when i save the page?
I was saving dates of 8/10/2006 and when I went to 10/27/2006, the column
width wasn't wide enough. I apologize for my last post, I was wrong. I adjusted the width and it worked perfectly! Thank you so much! I really appreciate it! Have a great day. "Amanda" wrote: It was wide enough to save all of the other dates but why not now and the last time I entered a date? Also, when I leave the box the date will automatically change to the ####. "PCLIVE" wrote: Maybe your column width isn't wide enough to display the full date. Regards, Paul "Amanda" wrote in message ... I typed in a date, then save as and the date changed to a row of ######. I didn't notice that the last time I entered a date on a worksheet that it did the same thing. I went into format column and it didn't help. Any ideas? Thank you for your help in advance! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does my date change to #### when i save the page?
Glad to help.
Paul :-) "Amanda" wrote in message ... I was saving dates of 8/10/2006 and when I went to 10/27/2006, the column width wasn't wide enough. I apologize for my last post, I was wrong. I adjusted the width and it worked perfectly! Thank you so much! I really appreciate it! Have a great day. "Amanda" wrote: It was wide enough to save all of the other dates but why not now and the last time I entered a date? Also, when I leave the box the date will automatically change to the ####. "PCLIVE" wrote: Maybe your column width isn't wide enough to display the full date. Regards, Paul "Amanda" wrote in message ... I typed in a date, then save as and the date changed to a row of ######. I didn't notice that the last time I entered a date on a worksheet that it did the same thing. I went into format column and it didn't help. Any ideas? Thank you for your help in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have the date in a spreadsheet change automically. | Excel Discussion (Misc queries) | |||
| I need a formula that change all date by putting in one date | Excel Worksheet Functions | |||
| change date on page set up | New Users to Excel | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| save multiple page setups in Excel | Excel Worksheet Functions | |||
Linear Mode
