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

rcavedo

New Member
Joined
Apr 14, 2002
Messages
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
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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
 
Upvote 0
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:
 
Upvote 0
Actually NOT
The values and formulas in the cell MUST remain the same.
I need the text ONLY when the spreadsheet is printed.
 
Upvote 0
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...
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top