| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Storing numbers in text fields
Hi,
I have a column which I format as follows - Columns("B:D").NumberFormat = "@" The issue is that some of the fields in this column contain numbers and excel is flagging the fact that numbers are being saved as text. I don't wan't excel to do this, what should I do? Public value As String ... Cells(RowCount, 3) = value My column - IDs 9899389 9A37884 9882D23 9288930 Thanks, Barry. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strategy Needed for storing data in these fields | Excel Discussion (Misc queries) | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Text fields with numbers in .csv file | Excel Programming | |||
| adding cells after stripping numbers out of text fields | Excel Discussion (Misc queries) | |||
| storing numbers within the macro | Excel Programming | |||
Threaded Mode
