| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
my columns have changed to show numbers and formula are different
Working in excel i have found my colum values have changed from letters to
numbers and the formula i am calculating have changed |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my columns have changed to show numbers and formula are different
Ian,
It's because the first workbook you opened in the session was set to R1C1. Tools|Options - General tab and un-check R1C1. Mike "Ian" wrote: Working in excel i have found my colum values have changed from letters to numbers and the formula i am calculating have changed |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my columns have changed to show numbers and formula are different
try
Tools Options General uncheck R1C1 reference style -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Ian" wrote: Working in excel i have found my colum values have changed from letters to numbers and the formula i am calculating have changed |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
my columns have changed to show numbers and formula are differ
Oops, should read
Tools Options General check R1C1 reference style because your R1C1 have been unchecked. -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Francis" wrote: try Tools Options General uncheck R1C1 reference style -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Ian" wrote: Working in excel i have found my colum values have changed from letters to numbers and the formula i am calculating have changed |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns headings changed to numbers in all of my worksheets | New Users to Excel | |||
| is there a formula to show the diference between numbers? | Excel Discussion (Misc queries) | |||
| Columns headings have changed to numbers instead of letters | Excel Worksheet Functions | |||
| I want the total in numbers to show not the formula | Excel Discussion (Misc queries) | |||
| formula to show ranges in columns | Excel Worksheet Functions | |||
Linear Mode
