xp
excel 2k

Hi,

I have a spreadsheet with certain alphanumeric and sometimes numeric values only. I have formated the column as text, but sometimes, the values are shrank in this way 1.3209E+11. My ? is how can I get rid of this and replace it with its true value 132090115901? If there is a way to do this without writing some code, then great. Please let me know. otherwise maybe the code bellow could be the basis.

Thanks for your anticipated answers.

Alex

Typically that means the column is too narrow. Adjust column width and see what happens.

resizing the column does not change a thing.

Then try to format the cell as Number rather than text.

However, if you want all to be text (except when number) then code is the way to go. Perhaps check to see whether it is numeric or text, then change formatting appropriately.

Alex

How is the data being put on the worksheet?

Have you tried formatting as Text before the data is put on the worksheet?