| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting text cell to numeric cell
In a column (Excel2007) that is correctly formatted as numeric, one cell has
=INT(15/0.85+0.5) and has correct format as numeric, another cell has =INT(75/0.85+0.5) and is formatted as text €“ both cells show actual values (not formula). All the cells(over 1000) in this column have similar content, and all except TWO have correct numeric format. I have tried, without success, various ways to change the 2 text cells to numeric . I am baffled by this (why these 2 cells are different and why I cannot change their format). Any comments/suggestions ? SM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| function for converting numeric value of cell say i,e 65,000 to wo | Excel Worksheet Functions | |||
| Converting time from text to numeric | Excel Worksheet Functions | |||
| Converting Numeric values to Text | Excel Worksheet Functions | |||
| converting text to numeric data | Excel Worksheet Functions | |||
| Converting Text into a Numeric Value and Totalling | Excel Worksheet Functions | |||
Threaded Mode
