Get instant live expert help on I need help with excel general format
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a column with the mixed date format. Some of them are in date format and some are in general format. I need everything to be in date format.
Solved by O. Y. in 15 mins
hi there, I can't change the date to general, under format. Is there a formula I can use? thank you
Solved by T. Q. in 16 mins
hi, i want to know in a column there are huge line items, i want to identify the column contain data is in text format or in general format
Solved by F. B. in 13 mins
Insert appropriate functions to calculate the average, highest, and lowest values in the Summary Statistics area (the range I21:K23) of the worksheet. Format the # of hours calculations as General number format with one decimal and the remaining calculations with Accounting number format.
Solved by S. J. in 26 mins
Good afternoon, I've created a spreadsheet yesterday to keep track on working hours of our personnel and such. As there are nightshifts to be done, it's also needed to calculate over night, which I managed to get working. Now I want to sum up all the total hours and it results in extreme high values. This due to the 'general' outcome being at around 22 when it's an overnight calculation. The general value of 22 will be multiplied by 24 by Excel and result in a high total times. Is there any way I can just sum up the results given by the time format [h]:mm;@? Or does it always calculate on the general format? Thank you!
Solved by C. C. in 18 mins