Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
green triangle in date cell
i have a file of three columns in which the end column is date's, i a
attemptimng to sort the file but it gives an error due to some of th date cell's having a green triangle in the left hand corner. if i select the cells with the green triangle, the error shows as. text dates with two digit year convert xx to 20xx and the column seems to behave. dose any one know how to change the date so that i can include it in macro normal formatting of the cells dose not seem to wor -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
green triangle in date cell
Hi
try the following: - select an empty cell and copy this cell - select your date range - goto 'Edit - Paste Special' and choose 'Add' -----Original Message----- i have a file of three columns in which the end column is date's, i am attemptimng to sort the file but it gives an error due to some of the date cell's having a green triangle in the left hand corner. if i select the cells with the green triangle, the error shows as. text dates with two digit year convert xx to 20xx and the column seems to behave. dose any one know how to change the date so that i can include it in a macro normal formatting of the cells dose not seem to work --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing green triangle in cell | Excel Worksheet Functions | |||
how do I get rid of the green triangle/upper left cell corner | Excel Discussion (Misc queries) | |||
Green Triangle in Upper Left Corner of Cell | New Users to Excel | |||
green triangle top left corner of cell in Excel | Excel Discussion (Misc queries) | |||
Green Triangle in Cell | Excel Discussion (Misc queries) |