Convert special character "#" to date

I need special character “#” on excel report to equal date (please see diagram). Is there an activity in StudioX that I can use to convert, or is this something I can achieve in Excel

image

@gustavo_marrufo - is it possible to share the sample spreadsheet?

sla metrics report.xlsx (15.6 KB)

@gustavo_marrufo - I don’t see any value behind the #, please look at the below screen shot where cell value shows #

Also, I tried converting this excel to csv. still no luck…

image

  1. If you want to copy the values from column E into column D, you can use a simple =E1 formula and call AutoFill to apply the formula to all the rows.

image

  1. Excel sometimes shows ### when the column is too narrow to fit the value. In this case you can use Autofit. But this does not seem you case, since the original value is actually the # character:

image

1 Like

@flavius - you mean does not ???

1 Like