View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nomail1983@hotmail.com is offline
external usenet poster
 
Posts: 58
Default How to change all numbers to x's?

On Mar 10, 6:28 pm, Dave Peterson wrote:
If they're all 3 or 4 digit numbers, you could try a custom number format of:
[999]"x,xxx";[0]"xxx";General


When I tried to extend this concept, I get an error. For example:

[9999]"xx,xxx";[999]"x,xxx";[0]"xxx";general

Is this form of custom format limited to only two conditions?

The Help page also shows only two conditions; but I do not see any
mention of a limit.