+ Reply to Thread
Results 1 to 13 of 13

auto calculate not working

  1. #1
    Noarmom
    Guest

    auto calculate not working

    I import a file and paste as CSV. I believe everything is considered text
    then, but there are numbers as well. The worksheet has over 4000 lines. I
    try to concantenate two cells (ie. a2 and b2). I use the function, but the
    result shows the formula. What I want is the new value or the string of
    words. I have checked my options and the auto calculate is turned on. I
    even try the various F9 keys.

  2. #2
    tim m
    Guest

    RE: auto calculate not working

    Under 'Tools'...'options'....'window options' do you have the formulas box
    checked? If so uncheck that box.

    "Noarmom" wrote:

    > I import a file and paste as CSV. I believe everything is considered text
    > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > result shows the formula. What I want is the new value or the string of
    > words. I have checked my options and the auto calculate is turned on. I
    > even try the various F9 keys.


  3. #3
    Noarmom
    Guest

    RE: auto calculate not working

    Tim,
    Thank you for your quick response. Formulas was/is unchecked.

    "tim m" wrote:

    > Under 'Tools'...'options'....'window options' do you have the formulas box
    > checked? If so uncheck that box.
    >
    > "Noarmom" wrote:
    >
    > > I import a file and paste as CSV. I believe everything is considered text
    > > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > > result shows the formula. What I want is the new value or the string of
    > > words. I have checked my options and the auto calculate is turned on. I
    > > even try the various F9 keys.


  4. #4
    tim m
    Guest

    RE: auto calculate not working

    Under 'Tools'...'options'....'window options' do you have the formulas box
    checked? If so uncheck that box.

    "Noarmom" wrote:

    > I import a file and paste as CSV. I believe everything is considered text
    > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > result shows the formula. What I want is the new value or the string of
    > words. I have checked my options and the auto calculate is turned on. I
    > even try the various F9 keys.


  5. #5
    Noarmom
    Guest

    RE: auto calculate not working

    Tim,
    Thank you for your quick response. Formulas was/is unchecked.

    "tim m" wrote:

    > Under 'Tools'...'options'....'window options' do you have the formulas box
    > checked? If so uncheck that box.
    >
    > "Noarmom" wrote:
    >
    > > I import a file and paste as CSV. I believe everything is considered text
    > > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > > result shows the formula. What I want is the new value or the string of
    > > words. I have checked my options and the auto calculate is turned on. I
    > > even try the various F9 keys.


  6. #6
    tim m
    Guest

    RE: auto calculate not working

    Under 'Tools'...'options'....'window options' do you have the formulas box
    checked? If so uncheck that box.

    "Noarmom" wrote:

    > I import a file and paste as CSV. I believe everything is considered text
    > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > result shows the formula. What I want is the new value or the string of
    > words. I have checked my options and the auto calculate is turned on. I
    > even try the various F9 keys.


  7. #7
    Noarmom
    Guest

    RE: auto calculate not working

    Tim,
    Thank you for your quick response. Formulas was/is unchecked.

    "tim m" wrote:

    > Under 'Tools'...'options'....'window options' do you have the formulas box
    > checked? If so uncheck that box.
    >
    > "Noarmom" wrote:
    >
    > > I import a file and paste as CSV. I believe everything is considered text
    > > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > > result shows the formula. What I want is the new value or the string of
    > > words. I have checked my options and the auto calculate is turned on. I
    > > even try the various F9 keys.


  8. #8
    tim m
    Guest

    RE: auto calculate not working

    Under 'Tools'...'options'....'window options' do you have the formulas box
    checked? If so uncheck that box.

    "Noarmom" wrote:

    > I import a file and paste as CSV. I believe everything is considered text
    > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > result shows the formula. What I want is the new value or the string of
    > words. I have checked my options and the auto calculate is turned on. I
    > even try the various F9 keys.


  9. #9
    Noarmom
    Guest

    RE: auto calculate not working

    Tim,
    Thank you for your quick response. Formulas was/is unchecked.

    "tim m" wrote:

    > Under 'Tools'...'options'....'window options' do you have the formulas box
    > checked? If so uncheck that box.
    >
    > "Noarmom" wrote:
    >
    > > I import a file and paste as CSV. I believe everything is considered text
    > > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > > result shows the formula. What I want is the new value or the string of
    > > words. I have checked my options and the auto calculate is turned on. I
    > > even try the various F9 keys.


  10. #10
    tim m
    Guest

    RE: auto calculate not working

    Under 'Tools'...'options'....'window options' do you have the formulas box
    checked? If so uncheck that box.

    "Noarmom" wrote:

    > I import a file and paste as CSV. I believe everything is considered text
    > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > result shows the formula. What I want is the new value or the string of
    > words. I have checked my options and the auto calculate is turned on. I
    > even try the various F9 keys.


  11. #11
    Noarmom
    Guest

    RE: auto calculate not working

    Tim,
    Thank you for your quick response. Formulas was/is unchecked.

    "tim m" wrote:

    > Under 'Tools'...'options'....'window options' do you have the formulas box
    > checked? If so uncheck that box.
    >
    > "Noarmom" wrote:
    >
    > > I import a file and paste as CSV. I believe everything is considered text
    > > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > > result shows the formula. What I want is the new value or the string of
    > > words. I have checked my options and the auto calculate is turned on. I
    > > even try the various F9 keys.


  12. #12
    tim m
    Guest

    RE: auto calculate not working

    Did you format the row you are putting the concatenate as general before
    entering the formula? (Also even numbers can be considered text if imported
    as text I believe.)

    "Noarmom" wrote:

    > Tim,
    > Thank you for your quick response. Formulas was/is unchecked.
    >
    > "tim m" wrote:
    >
    > > Under 'Tools'...'options'....'window options' do you have the formulas box
    > > checked? If so uncheck that box.
    > >
    > > "Noarmom" wrote:
    > >
    > > > I import a file and paste as CSV. I believe everything is considered text
    > > > then, but there are numbers as well. The worksheet has over 4000 lines. I
    > > > try to concantenate two cells (ie. a2 and b2). I use the function, but the
    > > > result shows the formula. What I want is the new value or the string of
    > > > words. I have checked my options and the auto calculate is turned on. I
    > > > even try the various F9 keys.


  13. #13
    Guest

    Re: auto calculate not working

    Hi

    It sounds like your cell was formatted as Text before you typed in the
    formula. Format it as General and re-enter your formula.
    Just because a file is CSV does not mean that all entries are treated as
    text. Numbers will still remain numbers.

    Andy.

    "tim m" <timm@discussions.microsoft.com> wrote in message
    news:9F5F1941-14D3-469D-A6C4-A2117E40FC75@microsoft.com...
    > Did you format the row you are putting the concatenate as general before
    > entering the formula? (Also even numbers can be considered text if
    > imported
    > as text I believe.)
    >
    > "Noarmom" wrote:
    >
    >> Tim,
    >> Thank you for your quick response. Formulas was/is unchecked.
    >>
    >> "tim m" wrote:
    >>
    >> > Under 'Tools'...'options'....'window options' do you have the formulas
    >> > box
    >> > checked? If so uncheck that box.
    >> >
    >> > "Noarmom" wrote:
    >> >
    >> > > I import a file and paste as CSV. I believe everything is considered
    >> > > text
    >> > > then, but there are numbers as well. The worksheet has over 4000
    >> > > lines. I
    >> > > try to concantenate two cells (ie. a2 and b2). I use the function,
    >> > > but the
    >> > > result shows the formula. What I want is the new value or the string
    >> > > of
    >> > > words. I have checked my options and the auto calculate is turned
    >> > > on. I
    >> > > even try the various F9 keys.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1