Everyday Pensacola

A place to discuss Pensacola, Florida area topics as well as the rest of the nation/world. To write a post, you must register and log in.
 
HomeHome  RegisterRegister  Log in  

Share | 
 

 Issue w/Excel (.xlxs)... looking for some help

View previous topic View next topic Go down 
AuthorMessage
riceme

avatar

Posts : 3098
Join date : 2012-12-02
Age : 45
Location : Fox, Alaska

PostSubject: Issue w/Excel (.xlxs)... looking for some help   Fri Mar 29, 2013 3:45 pm

I'm pretty adept with Excel... I wouldn't necessarily say that I'm an expert, but I can do everything my job requires and then some. I love the program... it's super nifty for all sorts of things, and I use it to track my personal finances as well as at using it daily for work. I worked a couple regular days then a couple 14-hr days this week, so I'm catching up on some personal finance malarkey today.

Anyhow, I came across an issue in .xlxs Excel today that I cannot seem to troubleshoot... in the very simplest of functions, no less! I went to SUM a column of + and - transactions and the SUM came out to a very obviously too large number. I went to the previous month and performed the same function and got the same (or similar) result at which time I realized that Excel was reading the - transactions as +'s. ???!!!

I have never before seen or heard of this, and went through to ensure there were no accidental spaces or anything hinky, and there isn't... Any ideas from our Excel users? I'd surely appreciate it.

Like a Star @ heaven Many thanks!
Back to top Go down
riceme

avatar

Posts : 3098
Join date : 2012-12-02
Age : 45
Location : Fox, Alaska

PostSubject: Re: Issue w/Excel (.xlxs)... looking for some help   Fri Mar 29, 2013 4:17 pm

Huh. Well I figgered it out. I went into Format Cells and changed the column/s to Currency :: $USD and that resolved the issue.

Weird... like I said, I've never before had an issue with SUMming data that was in the GENERAL format that I recall... but then, I seem to recall that I recently had a Windows Update that effected Excel, and maybe that was the issue.

Anyhoo, thanks anyhow! Wink

Figure I'll leave this here for others knowledge and/or commentary.
Back to top Go down
Ghost Rider
Admin
avatar

Posts : 338
Join date : 2012-11-18

PostSubject: Re: Issue w/Excel (.xlxs)... looking for some help   Fri Mar 29, 2013 4:30 pm

riceme wrote:
Huh. Well I figgered it out. I went into Format Cells and changed the column/s to Currency :: $USD and that resolved the issue.

Weird... like I said, I've never before had an issue with SUMming data that was in the GENERAL format that I recall... but then, I seem to recall that I recently had a Windows Update that effected Excel, and maybe that was the issue.

Anyhoo, thanks anyhow! Wink

Figure I'll leave this here for others knowledge and/or commentary.

Glad you found the problem. I was going to ask you to make sure that your number format was correct.

I am some what an expert with Excel. I have developed spreadsheets using them for years. I have a few that have been copyrighted and are proprietary.

_________________
The tyrant will always find a pretext for his tyranny, and it is useless for the innocent to try by reasoning to get justice, when the oppressor intends to be unjust.
Back to top Go down
riceme

avatar

Posts : 3098
Join date : 2012-12-02
Age : 45
Location : Fox, Alaska

PostSubject: Re: Issue w/Excel (.xlxs)... looking for some help   Fri Mar 29, 2013 6:47 pm

Ghost_Rider1949 wrote:
riceme wrote:
Huh. Well I figgered it out. I went into Format Cells and changed the column/s to Currency :: $USD and that resolved the issue.

Weird... like I said, I've never before had an issue with SUMming data that was in the GENERAL format that I recall... but then, I seem to recall that I recently had a Windows Update that effected Excel, and maybe that was the issue.

Anyhoo, thanks anyhow! Wink

Figure I'll leave this here for others knowledge and/or commentary.

Glad you found the problem. I was going to ask you to make sure that your number format was correct.

I am some what an expert with Excel. I have developed spreadsheets using them for years. I have a few that have been copyrighted and are proprietary.

Thanks, GR... I appreciate it. I've been using Excel pretty much all day every day for about 14-years and have learned by doing for the most part, which is how I learn best.

Maybe I'm having a brainfart, but I don't recall that I've ever before had an issue w/SUM in General format. However, I did only get a few hours sleep last night... damn insomnia! So, who knows!? lol.
Back to top Go down
Eric

avatar

Posts : 9735
Join date : 2012-07-30
Age : 66
Location : Hoover, AL & Pensacola when I'm lucky

PostSubject: Re: Issue w/Excel (.xlxs)... looking for some help   Fri Mar 29, 2013 8:13 pm

I used to use Excel a lot back in the 1990's, but have forgotten a bunch of it. I was thinking it was a column definition problem, but I was just taking a SWAG.

_________________
Ideas are funny little things, they won't work unless you do.
Back to top Go down
http://ericericson.net
riceme

avatar

Posts : 3098
Join date : 2012-12-02
Age : 45
Location : Fox, Alaska

PostSubject: Re: Issue w/Excel (.xlxs)... looking for some help   Fri Mar 29, 2013 8:38 pm

Yer SWAG was right on. I musta been having a brain fart. I's needs sum sleeps before I go out to watch the Friday night fights!
Back to top Go down
Melissa
Admin
avatar

Posts : 1324
Join date : 2012-07-30
Location : A wild garden

PostSubject: Re: Issue w/Excel (.xlxs)... looking for some help   Thu Apr 04, 2013 4:07 am

I have no expertise whatsoever with Excel, but I know someone who does. If you encounter any other problems, Riceme, I'll ask him next time I see him. (EDIT: It looks like Ghost and Eric can handle any problems. Just another reason I love our forum!)

I need to get in there and teach myself Excel. We use it at work, but I've always depended on our resident Excel guru to solve any problems. I do delegate well. silent
Back to top Go down
http://www.ouroasis.forumotion.com
Ghost Rider
Admin
avatar

Posts : 338
Join date : 2012-11-18

PostSubject: Re: Issue w/Excel (.xlxs)... looking for some help   Thu Apr 04, 2013 10:06 am

PBulldog2 wrote:
I have no expertise whatsoever with Excel, but I know someone who does. If you encounter any other problems, Riceme, I'll ask him next time I see him. (EDIT: It looks like Ghost and Eric can handle any problems. Just another reason I love our forum!)

I need to get in there and teach myself Excel. We use it at work, but I've always depended on our resident Excel guru to solve any problems. I do delegate well. silent

PB that's the way it usually happens. Someone designs the database to suit the needs of the client/office and then entering/changing the data then becomes a piece of cake.

_________________
The tyrant will always find a pretext for his tyranny, and it is useless for the innocent to try by reasoning to get justice, when the oppressor intends to be unjust.
Back to top Go down
Sponsored content




PostSubject: Re: Issue w/Excel (.xlxs)... looking for some help   

Back to top Go down
 
Issue w/Excel (.xlxs)... looking for some help
View previous topic View next topic Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Everyday Pensacola :: Hobbies and Personal Interests :: Computers-
Jump to: