Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Easy formula question
I know this is very simple but for some reason i am drawing a blank...
I am trying to use a formula to make copy info from one cell to another automatically, so i don't have to ocontinually type info that appears twice in the sheet. when i create the formula =V6 all that shows up is =V6 instead of the data from the cell v6. Please help |
#2
|
|||
|
|||
The problem is, the cell you are typing the =V6 in has somehow gotten
formated as TEXT. You need to get it returned to General format. Click on the cell, then up in the formula bar where the =V6 appears, delete the equal sign, then press enter.........then do it again and put the equal sign back in......it should change to a real formula and display the results from V6.......... Vaya con Dios, Chuck, CABGx3 "BabyBlueAXiD" wrote in message ... I know this is very simple but for some reason i am drawing a blank... I am trying to use a formula to make copy info from one cell to another automatically, so i don't have to ocontinually type info that appears twice in the sheet. when i create the formula =V6 all that shows up is =V6 instead of the data from the cell v6. Please help |
#3
|
|||
|
|||
The cell is formatted as text? "=v6" shows at the left of the cell?
Make sure the cell is formatted as general before entering or changing the contents. Greetings from New Zealand Bill K "BabyBlueAXiD" wrote in message ... I know this is very simple but for some reason i am drawing a blank... I am trying to use a formula to make copy info from one cell to another automatically, so i don't have to ocontinually type info that appears twice in the sheet. when i create the formula =V6 all that shows up is =V6 instead of the data from the cell v6. Please help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question | Excel Worksheet Functions | |||
formula question | Excel Worksheet Functions | |||
time formula question... | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
SUM array formula question | Excel Worksheet Functions |