Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Number to Text
Is it possible to format numbers into text from vba code? The situation is
that we insert data from a database into an Excel spreadsheet. One of the columns is an address column. The address column often has normal address data, but sometimes it will only contain a number like 1435, which causes Excel to treat that cells data as a number. So when we import the data back from Excel the column is misread because of the different formats for the cells. The database export unfortunately wipes out the column type, so changing its format type to text does nothing. Can the format command in VBA change a cells type? Thanks for the help, ACFalcon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
How to change text format .126 to number format 0.126 ? | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel |