problem with formatting

  • Thread starter Thread starter mcnewsxp
  • Start date Start date
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.
 
Hi
try formating this column as 'Text' (goto 'Format - Cells')
 
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.
 
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.
 
You must log in or register to reply here.

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

Conditionally formatting text and numbers differently 1
CSV text data altered on file open 4
Conditional Formatting Question 3
automatic formatting on import of .DIF files 3
converting text cell to numeric cell 5
Format .txt file contents to numeric format will not work - help! 3
Default Date Format in Excel 3
Numeric values as character in CSV 3

Back
Top