ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Easy formula question (https://www.excelbanter.com/excel-worksheet-functions/34154-easy-formula-question.html)

BabyBlueAXiD

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

CLR

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




Bill Kuunders

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





All times are GMT +1. The time now is 08:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com