ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatic Format Change: General to Date (https://www.excelbanter.com/excel-discussion-misc-queries/239350-automatic-format-change-general-date.html)

Gustavo[_2_]

Automatic Format Change: General to Date
 
Hello.

I apologize if duplicate, but tried looking for something similar in the
forum and didn't have luck.

Mi problem is that I have a file (new, not imported from a previous version)
that works fine until one point when all the numbers are changed in the
format from General to Date format. What can I do to prevent Excel of doing
this?

Thank you!

Bob I

Automatic Format Change: General to Date
 
Sounds like you are pasting in text that looks like dates. Pre-format as
text first.

Gustavo wrote:

Hello.

I apologize if duplicate, but tried looking for something similar in the
forum and didn't have luck.

Mi problem is that I have a file (new, not imported from a previous version)
that works fine until one point when all the numbers are changed in the
format from General to Date format. What can I do to prevent Excel of doing
this?

Thank you!




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

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