| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting dates in cells.
Problem: Dates are returned in cells as 5 digit number. Does not change to
date format when selections are made in cell formatting. What is wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting dates in cells.
Hi
If your 5 digit numbers are Text instead of Numeric, they will not be seen by Excel as a serial day number, and will not be converted to a date format. Check to make sure they are numeric. -- Regards Roger Govier "BMR" wrote in message ... Problem: Dates are returned in cells as 5 digit number. Does not change to date format when selections are made in cell formatting. What is wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting dates in cells.
The numbers you are looking at might really be text. Look for the ' in front
of them. If so, multiply them by 1, then format them as dates. "BMR" wrote: Problem: Dates are returned in cells as 5 digit number. Does not change to date format when selections are made in cell formatting. What is wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I have formatting toolbar active for the unprotected(unlocked) cells of the protected worksheet??? | Excel Discussion (Misc queries) | |||
| Chart formatting with dates | Charts and Charting in Excel | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
| How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Linear Mode
