problem with formatting

M

mcnewsxp

is there a way to get excel to not format a column as numeric even if when
the contents of the cell contains only numeric characters? this 'feature'
is very problematic when using excel as a temporary data container.
 
M

mcnewsxp

thought of that.
doesn't help for import into access or sql server.
placing an apostrophe in first cell works, but you shouldn't have to do
that.
 
D

DanF

Format the cells as text as the previous poster suggested

Then highlight the cells and copy them. Then Paste Special and copy only the values back.
 
Top