Convert excel cell format to general


#1

Im confronting with problem that date data is expressed as ###### in excel cell
Threfore, i would like to change the cell format to general. However, im in a situation that i cannot utilize
send hotkey activity.

How should i change cell format to general from other formats??


#2

A way you can solve this is to write a macro that will add an apostrophe (’) before each date. This will force it to be of the text type, and when you read the cell, it will disregard the apostrophe, and it will not show up in the cell.