0
votes
1answer
117 views

cell format excel number to text

I have a file with 4 columns and over 7000 rows. The columns are formatted as Number or Geral. But I'm using a plugging for php (SimpleXLSX) to read the xlsx file and create queries to insert into a ...
1
vote
2answers
7k views

How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL? (Still didn't got satisfactory answer)

I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type ...
0
votes
1answer
730 views

Format Excel cells to display as '##:##:##'

I'm trying to format cells in Excel so that they display the total duration of phone calls as hh:mm:ss, but Excel is giving me errors. Sometimes durations are only mm:ss (49:10), or even just ss ...
3
votes
3answers
8k views

How to format a Microsoft Excel 2007 cell in hexadecimal?

I would like a format a cell in Microsoft Excel 2007 in hexadecimal but am not finding how to do this. Is there a built-in way to change the base from 10 to 16 for a cell?
1
vote
1answer
101 views

Stop Microsoft Excel 2007 from formatting anything?

How can I stop Excel 2007 from modifying any character, I don't want to modify the date in any way, I don't want to modify misspells, nothing. I just want to see the exact text I'm writing.
3
votes
1answer
2k views

tab-shape or round corner background in Excel

In the below screenshot, you can see that each blue group header has a tab-shape or round corner background. Does anyone know to to create it? Source