0
votes
1answer
44 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
4k 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
607 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
6k 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
99 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.
2
votes
1answer
1k views

Excel graphs: I have created a template graph format but how do I apply it?

I've created a format that I like. I now need to apply this format to over 900 graphs! I've seen we can save a format as a template for future use, however, I can't find the place where I have the ...
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