K kath99 Distinguished Jul 12, 2011 1 0 18,510 Jul 12, 2011 #1 Hello, When using Excel I have my cells formatted as dd, when I add 31+7 is gives me 38 instead of 07 Thanks
Hello, When using Excel I have my cells formatted as dd, when I add 31+7 is gives me 38 instead of 07 Thanks
hang-the-9 Titan Mar 25, 2010 20,158 284 124,800 Jul 12, 2011 #2 Make sure that cell you are in is the same format as the others. I just tried in Excel 2003, when I used the formula =31+7 got 07 no issues. Maybe check to make sure you have the latest service pack.
Make sure that cell you are in is the same format as the others. I just tried in Excel 2003, when I used the formula =31+7 got 07 no issues. Maybe check to make sure you have the latest service pack.