fog_2003 Posted November 29, 2006 Share Posted November 29, 2006 I am conecting to an Excel spreadsheet via php odbc_conn funtion. It works but I have a list of room numbers like this in excel140014011402and when I retrieve the same numbers via php it comes out like this1400.01401.0I tried formatting the data differently in Excel and nothing happened. Anyone know why this would be happening or how to reformat the variables in php. Thanks Link to comment https://forums.phpfreaks.com/topic/28827-connecting-to-excel-via-odbc/ Share on other sites More sharing options...
Psycho Posted November 29, 2006 Share Posted November 29, 2006 number_format($variable,0,"","")http://us2.php.net/manual/en/function.number-format.php Link to comment https://forums.phpfreaks.com/topic/28827-connecting-to-excel-via-odbc/#findComment-131960 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.