Help! Urgent need.
Somehow i think i have changed my defaul number format from "general" to "date" so for things like my graphs...........the y-axis is not numbers but instead "dates".
any idea how to fix?
Right click the cells that you think are affected, click Format Cells, click Number, and then either choose General or Number.
Please leave a message after the beep!
Reset the Normal style to use General rather than Date.
that was it. I had to click the home tab and then under styles change SEVERAL of the "normal" styles. For some reason the "number" format was changed from "general" to some crazy date format.
any idea how this could have automatically happened? Very scary! I was working on a macro for several weeks now and today i noticed that my latest rev had the default changed to some sort of date.
Any ideas how this could have happened?
I'm guessing you are using Excel 2007? There seems to be a strange bug that causes this bit I haven't seen a definite cause yet (lots of pivot tables seems to be one possibility) but you shouldn't really have lots of Normal styles.
i have several......i am enclosing a pic of the different types..........should i do something other than just change the default back to "general"?
Kinda worried somethign might be messed up somwhere.
Have you been doing a lot of copying between workbooks?
i just noticed that while i changed the default back to "general" there are some columns of data that even after i turned default back are still "date" and i have to go and manually change them to general.
Should i scrap this version and go back to a version of the program where i know i did not have this default change?
yes, the macro does copy and paste between workbooks.........i have about 20 files i have to open........i open one, copy the necessary info, paste it, close file and then on to the next one.
If you select one of the cells, you should be able to see in the style section which style is active for that cell, and then modify it accordingly.
If you have a previous version, it's probably not a bad idea to go back to it.
I'd paste as values then if you can, rather than a straight paste.
ok, i will check to see if i am pasting as values. thanks.
what about if i am assigning a value to a cell in my sheet based on the values in another sheet..............should this be paste special as well.
For example:
above is what i am doing now. should i cahnge?mysummary_wrksht_unDB.Range(alphacol(Monthcol1) & (last_row3 + 1)).Value = mysummary_wrksht_unDB.Range("B3").Value
No, that's fine as you are not pasting, merely assigning values.
question:
In my macro i am doing a lot of
.PasteSpecial Paste:=xlPasteValuesAndNumberFormats
I did this so that if i am copying a date and then pasting it , the date stays as a date and not sum number............if i change all of the pastespecials to this
.PasteSpecial Paste:=xlPasteValues
any recommendations on how to handle copying and pasting dates so that the actual date appears?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks