| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates display as "38854"
Hello,
Why are all my dates in one worksheet displaying as "38854" and similar numbers? I'm not sure what I did, but I was working on a VB macro and that's what happened. Also, all my percentages are displaying as "0.15" instead of "15%". Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates display as "38854"
Do you see the nice date in the formula bar?
If yes, try: tools|options|view tab|uncheck formulas Ctrl-` (backquote, the key to the left of the 1/! on my USA keyboard) is the shortcut toggle for this setting. Kamran wrote: Hello, Why are all my dates in one worksheet displaying as "38854" and similar numbers? I'm not sure what I did, but I was working on a VB macro and that's what happened. Also, all my percentages are displaying as "0.15" instead of "15%". Thanks. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates display as "38854"
Ah, I bet that's it. I never realized that the Display Formulas option had
that effect on formatted cells. Cool, I learned something today. Thanks Dave! Elkar "Dave Peterson" wrote: Do you see the nice date in the formula bar? If yes, try: tools|options|view tab|uncheck formulas Ctrl-` (backquote, the key to the left of the 1/! on my USA keyboard) is the shortcut toggle for this setting. Kamran wrote: Hello, Why are all my dates in one worksheet displaying as "38854" and similar numbers? I'm not sure what I did, but I was working on a VB macro and that's what happened. Also, all my percentages are displaying as "0.15" instead of "15%". Thanks. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates display as "38854"
THAT WAS IT!! I really appreciate it, now I can stop pulling my hair out.
"Dave Peterson" wrote: Do you see the nice date in the formula bar? If yes, try: tools|options|view tab|uncheck formulas Ctrl-` (backquote, the key to the left of the 1/! on my USA keyboard) is the shortcut toggle for this setting. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates display as "38854"
Your cell formatting was changed. Excel stores all dates as serial numbers
(ie. 38854). It is the Cell Format that causes the Serial Number to appear as (5/17/2006), or whatever. Same with percentages, Excel stores percentages as a decimal number. Again, it is the Cell Formatting that causes the appearance to change. Select your cells, then go to the FORMAT Menu and select CELLS. Then, on the Number Tab, select the appropriate format that you want to see (date, percentage, etc..) HTH, Elkar "Kamran" wrote: Hello, Why are all my dates in one worksheet displaying as "38854" and similar numbers? I'm not sure what I did, but I was working on a VB macro and that's what happened. Also, all my percentages are displaying as "0.15" instead of "15%". Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates display as "38854" | Excel Worksheet Functions | |||
| 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 | |||
Hybrid Mode
