Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates display as "38854"
What happens if you enter a new date into one of the cells? Or type over one
of the serial numbers with a date? Does the format change, or does it still display a serial number? If the new entry displays properly, then try this. Enter a 1 into any blank cell. Copy that cell. Select your existing data. From the Edit Menu, select "Paste Special". Click the "Values" and "Multiply" options. Click OK. If that still doesn't help, then I'm not sure what else to suggest. Perhaps more info on the VB code you're working on may lead to a clue? HTH, Elkar "Kamran" wrote: Unfortunately that's not it. All the dates in all locations on the sheet changed at once, and I made no format changes. They are all currently set for mm/dd/yyyy, but they all display in serial number anyway. And then there's the decimal display issue. I've never seen anything like this happen all at once. I even tried disabling the VB module that I was working when the problem started, but that didn't change anything. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
How do display a "+" or "-" sign when hiding columns? | Setting up and Configuration of Excel | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
what is syntax for if(between range of dates,"Q1","Q2")? | Excel Worksheet Functions |