LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default replacing with a tick

Hi, I have exported data fom access, in which some of the field contain
checkboxes. These appear as true and false in excel. Rather than manually
changing them indivdually to ticks and crosses, from the symbol menu, how can
I use the find and replace function to do this. I can't get the find and
replace function to recognise a "tick" as it just comes out as "P".
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Tick in validation list Naz Excel Discussion (Misc queries) 1 June 12th 06 01:30 PM
Change XY tick labels from numeric to text jennifer Charts and Charting in Excel 2 April 20th 06 08:33 PM
Replace with single tick - formula too long.... [email protected] Excel Discussion (Misc queries) 1 March 27th 06 05:21 PM
cells formatted to tick when text value "Y" if or null if "N" Jay Excel Discussion (Misc queries) 7 January 13th 06 09:16 AM
tick box, how to set up Tiddler Excel Discussion (Misc queries) 9 December 15th 05 06:08 AM


All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"