469,591 Members | 1,650 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,591 developers. It's quick & easy.

simple excel questions

I have two simple questions:

I am trying to create a document using an excel spreadsheet format. I am trying to create a column that will contain numbers, just plain numbers as in account numbers for credit cards. When I formet the cell for a "number" it automatically changes the last number of my entry to 0 and/or it changes the format of a simple number entry to things like 4567+11 or other odd combinations. What am I doing wrong in the formatting process to not be able to enter a simple list ofnumbers like: 12345678

also: suddenly when I hit my tab key on my keyboard, it is automattcally bringing up the excel page I have been working on. This has not happened before. Normally I can use the tabl to tab through applicatins etc., but as of today, all my tab does is bring up my faulty excel page.

thansk for any help
Apr 17 '07 #1
1 1141
I have two simple questions:

I am trying to create a document using an excel spreadsheet format. I am trying to create a column that will contain numbers, just plain numbers as in account numbers for credit cards. When I formet the cell for a "number" it automatically changes the last number of my entry to 0 and/or it changes the format of a simple number entry to things like 4567+11 or other odd combinations. What am I doing wrong in the formatting process to not be able to enter a simple list ofnumbers like: 12345678
Your "numbers" are actually text, since you are not performing computations on them. So type each one starting with a quote mark to make it text. Single quote will left-align the number in the cell, double quote will right-align it, ^ will center. Thus to right-align your sample number, type "12345678 (note: only the one quote at the beginning). This alignment can be changed later with an alignment command from the main menu.
Apr 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Eric Johannsen | last post: by
3 posts views Thread by ben | last post: by
3 posts views Thread by DC Gringo | last post: by
10 posts views Thread by serge calderara | last post: by
1 post views Thread by George | last post: by
7 posts views Thread by Alain \Mbuna\ | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.