View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tina tina is offline
external usenet poster
 
Posts: 139
Default variable number format in cell

Hi
How can i get cell to have 3 decimals places if value below 5 and 2 decimals
if between 5 and 50 and 1 decimal if greater than 50.

I think I know how to do by e a macro but can I use data validation or other
formula
Thanks Tina