Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 1st 04, 07:09 PM
burkeville
 
Posts: n/a
Default I enter numbers and they are stored as text

I have a large Excel spreadsheet that I have used for years. It is Excel 2002
now with SP3. For a while now my calcs are off because the numbers I enter in
cells are being stored as text. I understand how to change them to numbers,
but when I add new numbers, those store as text also. Constantly having to
convert text to numbers. Thanks for any help I can get. Bobby

  #3   Report Post  
Old December 1st 04, 07:44 PM
Ron Rosenfeld
 
Posts: n/a
Default

On Wed, 1 Dec 2004 11:09:04 -0800, "burkeville"
wrote:

I have a large Excel spreadsheet that I have used for years. It is Excel 2002
now with SP3. For a while now my calcs are off because the numbers I enter in
cells are being stored as text. I understand how to change them to numbers,
but when I add new numbers, those store as text also. Constantly having to
convert text to numbers. Thanks for any help I can get. Bobby


Select the cells where you are entering these numbers and, before you enter any
data, format the cells as General or as Number.


--ron
  #4   Report Post  
Old December 3rd 04, 01:21 AM
burkeville
 
Posts: n/a
Default

Ron, Thanks for coming to my aid. All of the cells in this spreadsheet have
been formated since I created the sheet in '96. Originally it was excel 97,
and through the years has been upgraded to 2002. This was done early 03. For
about the last 3 months though these same cells that were formatted in
numbers are now storing new numbers as text. Microsoft has a method I have
been using to change the format in ranges and I have also use the error
control to change individual cells. Thanks for any ideas. Bobby
"Ron Rosenfeld" wrote:

On Wed, 1 Dec 2004 11:09:04 -0800, "burkeville"
wrote:

I have a large Excel spreadsheet that I have used for years. It is Excel 2002
now with SP3. For a while now my calcs are off because the numbers I enter in
cells are being stored as text. I understand how to change them to numbers,
but when I add new numbers, those store as text also. Constantly having to
convert text to numbers. Thanks for any help I can get. Bobby


Select the cells where you are entering these numbers and, before you enter any
data, format the cells as General or as Number.


--ron

  #5   Report Post  
Old December 3rd 04, 01:21 AM
burkeville
 
Posts: n/a
Default

Don, Thanks for coming to my aid. All of the cells in this spreadsheet have
been formated since I created the sheet in '96. Originally it was excel 97,
and through the years has been upgraded to 2002. This was done early 03. For
about the last 3 months though these same cells that were formatted in
numbers are now storing new numbers as text. Microsoft has a method I have
been using to change the format in ranges and I have also use the error
control to change individual cells.

"Don Guillett" wrote:

Maybe you could pre-format the cells?

--
Don Guillett
SalesAid Software

"burkeville" wrote in message
...
I have a large Excel spreadsheet that I have used for years. It is Excel

2002
now with SP3. For a while now my calcs are off because the numbers I enter

in
cells are being stored as text. I understand how to change them to

numbers,
but when I add new numbers, those store as text also. Constantly having to
convert text to numbers. Thanks for any help I can get. Bobby






  #6   Report Post  
Old December 3rd 04, 01:59 AM
Ron Rosenfeld
 
Posts: n/a
Default

On Thu, 2 Dec 2004 17:21:02 -0800, "burkeville"
wrote:

Ron, Thanks for coming to my aid. All of the cells in this spreadsheet have
been formated since I created the sheet in '96. Originally it was excel 97,
and through the years has been upgraded to 2002. This was done early 03. For
about the last 3 months though these same cells that were formatted in
numbers are now storing new numbers as text. Microsoft has a method I have
been using to change the format in ranges and I have also use the error
control to change individual cells. Thanks for any ideas. Bobby
"Ron Rosenfeld" wrote:


Have you saved the workbook in the same format as the present Excel release, or
are you keeping it in the XL97 (or older) format?

When you enter a number into one of these cells, do you type it in from the
keyboard, or are you using a different method.

What is the format of the cell before you enter a new number that might get
changed to text?


--ron


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017