How to Excel Master Thread

[Excalibur]

Hey everybody. Thank G-d as I'm progressing professionally I'm running into more challenging tasks. I'm picking up a lot in Excel but still need help. I figure everyone could benefit from this thread that uses excel or is in accounting.

So, does anyone know how to extrapolate from a line on one excel workbook to another across multiple sheets?

TIA

[shulem92]

Hey everybody. Thank G-d as I'm progressing professionally I'm running into more challenging tasks. I'm picking up a lot in Excel but still need help. I figure everyone could benefit from this thread that uses excel or is in accounting.

So, does anyone know how to extrapolate from a line on one excel workbook to another across multiple sheets?

TIA

Are you aware that there already is an excel thread?
http://forums.dansdeals.com/index.php?topic=35830.0

[ChaimMoskowitz]

Need to save CC #'s. I was told to set the cell as text to save properly. It works but shows and error as "The number in this cell is formatted as text". How do I get rid of that error?

[aygart]

Need to save CC #'s. I was told to set the cell as text to save properly. It works but shows and error as "The number in this cell is formatted as text". How do I get rid of that error?

What is the issue with it showing that error

[ChaimMoskowitz]

What is the issue with it showing that error

Nothing but it bugs me. Seems there should be a way to store a 16 digit number without any errors.

[aygart]

Nothing but it bugs me. Seems there should be a way to store a 16 digit number without any errors.

It is an annoyance but the best way. Sometimes putting am apostrophe before the number will work.

[etech0]

It is an annoyance but the best way. Sometimes putting am apostrophe before the number will work.

+1

ETA: try this https://support.office.com/en-us/article/Fix-text-formatted-numbers-by-applying-a-number-format-6599c03a-954d-4d83-b78a-23af2c8845d0#__toc260840021

[ChaimMoskowitz]

ETA: try this https://support.office.com/en-us/article/Fix-text-formatted-numbers-by-applying-a-number-format-6599c03a-954d-4d83-b78a-23af2c8845d0#__toc260840021

That did it, thanks.

Now the next issue. 
Entering a number with leading zero(s) it deletes them. How do I get them to show?

[etech0]

That did it, thanks.

Now the next issue. 
Entering a number with leading zero(s) it deletes them. How do I get them to show?

YW. Put an apostrophe before the 0.

[ChaimMoskowitz]

Put an apostrophe before the 0.

Not trying to be a pain but that is an extra keystroke and it adds up when doing thousands. No way to format the cell for a four digit number which might have leading zeros?

[aygart]

Not trying to be a pain but that is an extra keystroke and it adds up when doing thousands. No way to format the cell for a four digit number which might have leading zeros?

Text

ETA, try formatting it as the last 4 of a zip code. I think that is an option.

[ChaimMoskowitz]

Text

Talk about being brain dead.   

[aygart]

Talk about being brain dead.   

See my edit.

I deal with this issue all the time and have not found a better way.

[ChaimMoskowitz]

See my edit.

I deal with this issue all the time and have not found a better way.

Text works just fine. My brain is not working today.

[bubbles]

If you don't realize till after the fact. =TEXT(A2,"0000") will add in a leading zero to any 3 digit number while maintaining 4 digit numbers as is

[ChaimMoskowitz]

If you don't realize till after the fact. =TEXT(A2,"0000") will add in a leading zero to any 3 digit number while maintaining 4 digit numbers as is

Nice, so entering "4" when the PIN is 0004 will show correctly as "0004"?

[etech0]

Nice, so entering "4" when the PIN is 0004 will show correctly as "0004"?

Yes