Convert formula to text

Question

Level 1

9 points

Convert formula to text

Does anyone know how to convert a column of formula results to text? I could go via export to csv and back again but....

MacBook, Mac OS X (10.4.10)

Posted on Nov 10, 2007 8:54 AM

Reply

Answer 1

Best reply

Ashka

Level 4

3,885 points

Nov 10, 2007 9:23 AM in response to mercergeo

You could try Inspector > Format > Text

Reply

Answer 2

KOENIG Yvan

Level 8

41,807 points

Nov 10, 2007 10:05 AM in response to mercergeo

Hello

Export to CSV would not export the formulas but their results.

Ashka gave the correct responce.
For my own use I don't call the Inspector but a small triangle in the Tool bars.

Yvan KOENIG (from FRANCE samedi 10 novembre 2007 19:02:03)

Reply

Answer 3

jaxjason

Level 5

5,035 points

Nov 12, 2007 10:08 AM in response to mercergeo

why not copy, then paste values from the edit menu? Or am i missing something?

Jason

Reply

Answer 4

5-vv

Level 3

685 points

Nov 12, 2007 3:22 PM in response to jaxjason

Jason's right, "Edit"/"Copy" then immediately "Edit"/"Paste Values" to replace the formulas with their results.

Reply

Answer 5

KOENIG Yvan

Level 8

41,807 points

Nov 13, 2007 1:06 AM in response to 5-vv

Hello

Once again I was reading too fast.

As the question was about pasting the rzesults only, the correct tool is Paste Values.

Yvan KOENIG (from FRANCE mardi 13 novembre 2007 10:06:34)

Reply