Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as Serial Values
Whilst working all my dates have started to show up as their serial values. I
tried to change the format back but it won't work. Can anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as Serial Values
"Lucy N" wrote in message
... Whilst working all my dates have started to show up as their serial values. I tried to change the format back but it won't work. Can anyone help? What format are the cells currently? Are you sure that you've got numbers in there, rather than text? [If you change the number of figures after the decimal point in Number format, does this change show up in the cells? If not, then you may need to do a Paste Special trick like adding zero or multiplying by 1 to convert from text to number, and then you should be able to format cells as date.] -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as Serial Values
Thanks for replyin.
The Format says number and date still. The data is the date with slashes in between e.g. 06/07/2006 My colleague told me in needed to put a ' in front of everything to get it to convert back but I was hoping there was something simpler. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as Serial Values
Do you see the real date in the formulabar, but those serial numbers in the
cell? If yes, try tools|options|view|uncheck formulas You may have hit the shortcut toggle in error: ctrl-` (ctrl-backquote, to the left of the 1/! on my USA keyboard) Lucy N wrote: Whilst working all my dates have started to show up as their serial values. I tried to change the format back but it won't work. Can anyone help? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as Serial Values
Check to see if you are perhaps in "Formula View" mode.
This would change "legal" XL dates to their serial values. You can toggle it on and off with: <Ctrl < ` That's the key containing the ~ (on my keyboard). -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Lucy N" wrote in message ... Thanks for replyin. The Format says number and date still. The data is the date with slashes in between e.g. 06/07/2006 My colleague told me in needed to put a ' in front of everything to get it to convert back but I was hoping there was something simpler. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dave Peterson
That is obviously what I'd done, thankyou so much, I'm working to a deadline
and thought I'd never get it sorted. Thanks again |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates as Serial Values
"Lucy N" wrote in message
... Thanks for replyin. The Format says number and date still. Is the format Number or is it Date? These are two different formats; it can't be both. The data is the date with slashes in between e.g. 06/07/2006 I thought you were saying that you were seeing the data as numbers, not as dates? Or are you saying that you see the date in the formula bar but the serial number when you see the cell in the sheet (or vice versa)? My colleague told me in needed to put a ' in front of everything to get it to convert back but I was hoping there was something simpler. Putting a ' in front will force it to be treated as text, which isn't what you want. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Text Values to Dates | Excel Discussion (Misc queries) | |||
formula to add dates. | Excel Worksheet Functions | |||
US dates to UK?? | Excel Worksheet Functions | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Convert three separate columns of values to dates | Excel Worksheet Functions |