refresh all cells in column

[Guest]

Hello, besides pressing F2 and ENTER 6000 times... is there a way to refresh
every cell in a column at once?

 

[Niek Otten]

Select the range. Edit>Replace, replace all "=" by "=". (without the quotes,
just a sort of re-entering the formulas)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

that's fabulous and I'm sure I will use it in the future... If I have a
column (A) of numbers that were formated general and changed to text (to keep
leading zeros)... and my formula in (C) .. a vlookup... will not show me the
data without refreshing the data in column A... is there another solution... ?

 

[Niek Otten]

Please give us your formulas, values, results and expected results.
I don't know *how* you changed your numbers to text, but that shouldn't be
necessary with the right custom formatting.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

I have a 'caseload report tab 1, service report tab 2.
tab 1 id numbers come to me with a ' before the numbers to keep the leading
zeros. tab 2 comes to be with the id numbers already converted to text, so it
keeps the leading zeros.
in tab 1 I used 'text to colunns' to get the ' not to import and was left
with my column of numbers.
tab 1 I have a named data range of primary name with column A ID, B,client,
C primary.
tab 2 I have lists of service dates with A ID number, B Client name, C
Vlookup(a2,primaryname,3,0)
Tab 1 ID and tab 2 ID are both formated as text.
I am have to F2,ENTER on each ID Cell in tab 2 (A) to have the C Vlookup
data flood in. Thanks

 

[Niek Otten]

There is probably still a space or another invisible character in your data.
Easiest is to convert all data to real numbers.
Format an empty cell as number and enter the number 1. Edit>Copy. Select
your "numbers", Edit>Paste Special, check Multiply.

You can still format with leading zeros; Format>Cells>Custom, enter 0000000
The required number of digits) in the Type box.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Some more very useful advice. The leading zeros are not constant... can have
0 to 6 leading zeros... I'm kindof done dealing with it for now.... thanks
for your help