Convert to values? edit|copy edit|paste special|values is one way. LBogie wrote:
D Dave Peterson Jul 13, 2005 #1 Convert to values? edit|copy edit|paste special|values is one way. LBogie wrote:
L LBogie Jul 14, 2005 #2 Thanks for the reply. Is there perhaps another wayto accomplish this? This way may cause the formatting to change.
Thanks for the reply. Is there perhaps another wayto accomplish this? This way may cause the formatting to change.
D Dave Peterson Jul 14, 2005 #3 I don't think I've ever seen the formatting change when I do this. What changed for you? You could do it cell by cell. Select a cell hit F2 hit F9 hit enter Select the next cell
I don't think I've ever seen the formatting change when I do this. What changed for you? You could do it cell by cell. Select a cell hit F2 hit F9 hit enter Select the next cell
