How to display and print a value different from that in cell

rcavedo · May 6th, 2002, 03:15 PM

How does one display and print a value that is different from that in a cell?

For extensive calculation purposes that involve both the column and the row a cell occupies, I have numeric values in all cells. However, in some cells that numeric value actually repersents text. There are only seven different values that represent text. The complication is that for further calucations the values MUST remain numeric.

Is there a way to retain the numeric value in the cell, but display the text it represents?

Thanks

Bob

Jack in the UK · May 6th, 2002, 03:22 PM

will converting the cell to text help

caution the cells will be dead if you do this the formula will be gone

copy pasete as value also works

_________________
If you can help a guy in trouble -
If you can sort that nagging problem -
Pease try, at home, at work or on a message board.

Others help you!
So PLEASE help if you can - If only the once.

Thank you -

Rdgs
======

[ This Message was edited by: Jack in the UK on 2002-05-06 14:33 ]

rcavedo · May 6th, 2002, 03:27 PM

Something happened to your answer. It was unreadable. Pqrts/words missing.

Jack in the UK · May 6th, 2002, 03:31 PM

dont be silly thats my readful noraml presentation, i cant spell read or write, but i use excel ok..

i have 3 briken fingers, so sorry very sorry ive let you down,

ill edit the original give me a minute..

please very sorry, i whish i could spell thou:

Jack in the UK · May 6th, 2002, 03:33 PM

edit compleated!

sorry again,,,

rcavedo · May 6th, 2002, 03:38 PM

Actually NOT
The values and formulas in the cell MUST remain the same.
I need the text ONLY when the spreadsheet is printed.

Jack in the UK · May 6th, 2002, 03:42 PM

in which case i would copy to another sheets and convert as ive said and then print..

delete this sheet and back to like sheet.

takes seconds to do...

rcavedo · May 6th, 2002, 03:52 PM

Close but were not there yet.
the spreadsheet contains over a thousand values and formulas. The ones that need to be text are the result of calculations and will occur at what seems to be random. Locating each cell that needs to be converted to text even in a copy of the original spreadsheed would be, for me, time consuming and difficult.

Jack in the UK · May 6th, 2002, 04:00 PM

on original crtl+A (that selects all)
select cell a1 on new sheet and right click paste special and click values

takes oh 30 seconds ,,, hope thats ok

rcavedo · May 6th, 2002, 04:07 PM

Yes I understand that that gives a total copy of the spreadsheet including all formulas formattinmg comments etc. But that still does not solve the problem of automatically changing the value of a cell to text depending on the value in the cell.
I still have to search the spread sheet for the special values and change each one. Each time I change a value to text that would cause other values to be calculated incorrectly. Thus defeating the purpose of the copy of the original spreadsheet.

May 6th, 2002, 03:31 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	dont be silly thats my readful noraml presentation, i cant spell read or write, but i use excel ok.. i have 3 briken fingers, so sorry very sorry ive let you down, ill edit the original give me a minute.. please very sorry, i whish i could spell thou: __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 6th, 2002, 03:33 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	edit compleated! sorry again,,, __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 6th, 2002, 03:42 PM	#7
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	in which case i would copy to another sheets and convert as ive said and then print.. delete this sheet and back to like sheet. takes seconds to do... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

May 6th, 2002, 04:00 PM	#9
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	on original crtl+A (that selects all) select cell a1 on new sheet and right click paste special and click values takes oh 30 seconds ,,, hope thats ok __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 03:15 PM	#1
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	How does one display and print a value that is different from that in a cell? For extensive calculation purposes that involve both the column and the row a cell occupies, I have numeric values in all cells. However, in some cells that numeric value actually repersents text. There are only seven different values that represent text. The complication is that for further calucations the values MUST remain numeric. Is there a way to retain the numeric value in the cell, but display the text it represents? Thanks Bob

May 6th, 2002, 03:22 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	will converting the cell to text help caution the cells will be dead if you do this the formula will be gone copy pasete as value also works _________________ If you can help a guy in trouble - If you can sort that nagging problem - Pease try, at home, at work or on a message board. Others help you! So PLEASE help if you can - If only the once. Thank you - Rdgs ====== [ This Message was edited by: Jack in the UK on 2002-05-06 14:33 ]

May 6th, 2002, 03:27 PM	#3
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	Something happened to your answer. It was unreadable. Pqrts/words missing.

May 6th, 2002, 03:38 PM	#6
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	Actually NOT The values and formulas in the cell MUST remain the same. I need the text ONLY when the spreadsheet is printed.

May 6th, 2002, 03:52 PM	#8
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	Close but were not there yet. the spreadsheet contains over a thousand values and formulas. The ones that need to be text are the result of calculations and will occur at what seems to be random. Locating each cell that needs to be converted to text even in a copy of the original spreadsheed would be, for me, time consuming and difficult.

May 6th, 2002, 04:07 PM	#10
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	Yes I understand that that gives a total copy of the spreadsheet including all formulas formattinmg comments etc. But that still does not solve the problem of automatically changing the value of a cell to text depending on the value in the cell. I still have to search the spread sheet for the special values and change each one. Each time I change a value to text that would cause other values to be calculated incorrectly. Thus defeating the purpose of the copy of the original spreadsheet.