green triangle in date cell

A

alexanderd

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
 
F

Frank Kabel

Hi
try the following:
- select an empty cell and copy this cell
- select your date range
- goto 'Edit - Paste Special' and choose 'Add'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

identify green triangle in cell programatically? 5
A macro that deletes all green triangle error indicators in workbook 4
Getting rid of the green triangles in XL 2010 3
ignore error 1
VBA Conditional Formatting .IconSets plus one other icon/symbol 14
What is small green triangle in upper left corner of cell? 6
number format when returning value from odbc connection 2
remove little green error triangle - how loop through to ignore er 4

Top